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

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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)

Quick start tips for using the new MSSQL-CLI SQL query tool The new MSSQL-CLI command-line tool provides many enhancements over SQLCMD CLI that enable you to quickly write and run T-SQL queries across Linux, macOS and Windows.

Best practices for preventing a SQL injection attack One of the sneakiest ways for a hacker to invade your system is via a SQL injection attack. Expert Robert Sheldon explains how to keep hackers out.

How to stop SQL injection and prevent data compromises While they're some of the easiest attacks to prevent, SQL injections are also some of the least protected against forms of attack. Learn how to stop them with this advice.

SQL Server command-line utilities: sqlcmd SQL Server command-line utilities give database administrators a new way to access the database engine and its components. Learn about each utility and its command syntax, starting with the sqlcmd utility.

Using the OPENROWSET function in SQL Server Whether you're bulk loading data or connecting to an OLE DB data source, OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.

How to use SQL Developer to run SQL statements In this chapter, learn how to use SQL Developer to enter and execute SQL statements and scripts, work with a Snippets window, solve common syntax errors and more.

Have a question for an expert?

Please add a title for your question

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

Meet all of our AS/400 experts

View all AS/400 questions and answers

Please create a username to comment.

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

Dig Deeper on DB2 UDB (universal databases)

Related Q&A from Kent Milligan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.