Get started Bring yourself up to speed with our introductory content.

Run multiple SQL statements

How can I run multiple SQL statements within interactive SQL? I have tried using the :, " ,;, but it will not recognize...


No. I'd suggest using the iSeries Navigator SQL Script window. In addition to being able to run multiple statements (separated with ;) and a graphical interface, the iSeries Navigator interface has additional features and functions not available with STRSQL. There are self-study tutorials that can be downloaded for free.

The RUNSQLSTM CL command would be another consideration for green-screen interfaces.

More on this topic

Visit the ITKnowledge Exchange and get answers to your DB2 questions fast.

Check out this Search400.com Featured Topic: Expert advice on DB2 

Search400.com's targeted search engine: Get relevant information on DB2/400. 

The Best Web Links: Tips, tutorials and more. 



This was last published in January 2005

Dig Deeper on iSeries SQL commands and statements

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.