Home > IT Answers > AS/400 > Stored procedure
Nutangujar
895 pts.
 Stored procedure
AS/400, AS/400 stored procedures, RPG
how to capture the messages sent by Stored procedure..

the one which i'm using is programmed to returned '0001110' if certaine condition do not match...how will i capture this or where i'll see these messages...

Thanks,

NG



Software/Hardware used:
AS400
ASKED: September 10, 2009  2:18 PM
UPDATED: September 11, 2009  12:57 AM
RELATED QUESTIONS
Answer Wiki:
Memory is fuzzy but here goes... change your sql from call storproc1(parm1,parm2) to set :returnVal = storProc1(parm1,parm2) and create an rpgvariable returnVal of the correct type of the procedure return value or here's another although I don't see how it would work Select storProc1(parm1:parm2) into :returnVal Good luck Phil
Last Wiki Answer Submitted:  September 11, 2009  12:57 am  by  philpl1jb   44,220 pts.
All Answer Wiki Contributors:  philpl1jb   44,220 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _