Testing Stored Procedures under DB2 LUW

In lieu of coding test clients to test DB2 LUW stored procedures in COBOL, we offer the following options that do not require code:

• If you have the IBM Data Studio software installed, use it to execute the stored procedure, manually providing required parameter values.
• At a DB2 command prompt, connect to the database, then call the stored procedure as follows:

  C:> db2 call stored-procedure-name (parm1[, parm2…])

  For example:

  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 (?).