Home > IT Answers > SQL Server > Multiple SQL For (AS/400)
Help

Question

  Asked: Jul 24 2008   7:42 PM GMT
  Asked by: WSCST

Multiple SQL For (AS/400)


SQL Server administration, AS/400 and SQL

For (AS/400)
I need to create a source member with multiple sentences of sql:
i.e.
update aa....
update bb....
update cc....

, and then run these source member with runsqlstm.
Is it possible? which is the character to separate between sentences?
Thanks in advance

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
Last Answered: Jul 24 2008  8:49 PM GMT  by Alopez1571




Semicolon is the character for separating SQL sentences:

Update file1 set field1=value1; Update file2 set field2=value2
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and AS/400.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Gilly400  |   Jul 25 2008  9:04AM GMT

Hi,

This is no problem to do with RUNSQLSTM. Remember to end each statement with the semi-colon (;) and this should work fine.

Regards,

Martin Gilbert.