Clp Db2 Procedure Running Stored
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 2 articles for 0.370 sec
Ali wrote: > Hi, > > While browsing through the iSeries Info center, I got this info : The > CL CALL command cannot be used to invoke DB2 Stored Procedures. > > So, now my best bet is to try with the tool - EXCSQLSTM. > > I cannot use STRQM since I want to call the stored procedure > programatically from a CL and pass parameters to it. You can use a QM query for this. 1. Create your     

Group: comp.sys.ibm.as400.misc · Group Profile · Search for Clp Db2 Procedure Running Stored in comp.sys.ibm.as400.misc
Author: Jonathan Ball
Date: Nov 15, 2006 10:25

You use STRQM to create QMQRY objects (or CRTQMQRY command). To actually run the created QMQRY object, you'd use STRQMQRY command in your CL. It does accept parameters. One limitation it has is that it can run only one SQL statement per QMQRY. Ali wrote: Hi, While browsing through the iSeries Info center, I got this info : The CL CALL command cannot be used to invoke DB2 Stored
Show full article (1.91Kb) · Show article thread
    

Group: comp.sys.ibm.as400.misc · Group Profile · Search for Clp Db2 Procedure Running Stored in comp.sys.ibm.as400.misc
Author: Elvis
Date: Nov 15, 2006 08:29

Show full article (0.61Kb) · Show article thread