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

them.

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

  • How do I size a UPS unit?

    Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

  • How to enhance FTP server security

    If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

  • 3 ways to approach cloud bursting

    With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...

Close