> db2 -td@ -vf sp1.db2 
CREATE PROCEDURE sp1 (OUT p_c1 VARCHAR(100), OUT p_c2 VARCHAR(100))
LANGUAGE SQL
BEGIN

DECLARE cur_str  varchar(1000);

SET cur_str = ' ';
SET cur_str = cur_str ||' SELECT a , b , c ' ;
SET cur_str = cur_str ||'   FROM test      ' ;
SET cur_str = cur_str ||'  WHERE a = 13    ' ;
SET cur_str = cur_str ||'    AND b = 1     ' ;
 
set p_c1 = cur_str ;

SET cur_str = ' ';
SET cur_str = cur_str ||' SELECT a , b , c ' || chr(13)||chr(10);
SET cur_str = cur_str ||'   FROM test      ' || chr(13)||chr(10);
SET cur_str = cur_str ||'  WHERE a = 13    ' || chr(13)||chr(10);
SET cur_str = cur_str ||'    AND b = 1     ' || chr(13)||chr(10);

set p_c2 = cur_str ;

END

DB20000I  The SQL command completed successfully.

> db2 "call sp1(?,?)"

  Value of output parameters
  --------------------------
  Parameter Name  : P_C1
  Parameter Value :   SELECT a , b , c    FROM test        WHERE a = 13        AND b = 1    

  Parameter Name  : P_C2
  Parameter Value :   SELECT a , b , c
   FROM test     
  WHERE a = 13   
    AND b = 1    

  Return Status = 0