In lieu of coding test clients to test DB2 LUW stored procedures in COBOL, we offer the following options that do not require
- If you have the IBM Data Studio software installed, use it to execute the stored procedure, manually providing required parameter
- At a DB2 command prompt, connect to the database, then call the stored procedure as follows:
C:> db2 call stored-procedure-name (parm1[, parm2…])
C:> db2 connect to Sample
C:> db2 call GETPRML ('TEST', 'TEST', 0, 'TEST')
Note: If the sole required parameter is OUTPUT, represent it as a question mark (?).