Testing DB2 LUW Stored Procedures

For testing DB2 LUW stored procedures in PL/I, you can use options other than coding a test client that require no coding.

• If you have IBM's Data Studio product installed, you can use that to enter parameter information and execute the stored procedure.
• Use a DB2 command prompt by first connecting to database and then calling the stored be entering CALL <stored procedure name> (parm1, parm2…..)

If the parameter is OUTPUT only, specify a question mark (?).

For example, to test the stored procedure defined earlier in this section, enter:

db2 connect to Sample

db2 call GETPRML ('TEST', 'TEST', 0, 'TEST')