Running multiple SQL commands within a CL/QMQRY
Running multiple SQL commands within a CL/QMQRY does not recognize the semicolon (;) separator. Is there a PTF that is required?
Running multiple SQL commands within a CL/QMQRY does not recognize the semicolon (;) separator. Is there a PTF...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
that is required? I'm using V5R2.
Query Management query (created via the CRTQMQRY command) is a single SQL statement, thus multiple SQL statements are not supported. You can, however, execute multiple QM queries using the STRQMPRC command. The source file member specified in the STRQMPRC command would look something like this:
'RUN QUERY QMQUERY1'
'RUN QUERY QMQUERY2'
As a simpler alternative, you may want to look at using the RUNSQLSTM command. This command lets you run multiple SQL statements (separated by semicolons) that are stored in a source file member .