Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

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...

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 .

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Meet all of our AS/400 experts

View all AS/400 questions and answers

Start the conversation

Send me notifications when other members comment.

Register

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close