Stored Procedure(SQL)

[Raja Suthana Ku]

I have created a Stored procedure using RUNSQLSTM. My objective is to pass a parameter (*CHAR(10) and retrieve data from a physical file.

In the stored procedure I have given as

Create Procedure LTCAMSSRC/BUV97( IN USERID CHAR(10)) DYNAMIC RESULT SETS 1



SELECT PLANT,PROCESS FROM LTCAMSSRC/FPF2 WHERE USER = USERID;

This retutns only blank record .

Note : The results I am storing in a QTEMP file.Without parameter it is returning results to the outfile.

Pl. advice. Thanks