SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Commands

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
SQL Commands
Author Message
Denmark Serrano



Joined: 19 Jan 2001
Posts: 1

Post SQL Commands Reply with quote

I'm using DB2 UDB EEE v6. How can I make 24x7 execute multiple commands in one script?

Fri Jan 19, 2001 2:23 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Re: SQL Commands Reply with quote

If you use direct or ODBC DB2 connection, enclose your statements in BEGIN...END construct

For example:
BEGIN
SQL statement 1;
SQL statement 2;
END;

If you use Sybase, Oracle, or other vendor's DB2 gateway, you should use syntax for that vendor.

: I'm using DB2 UDB EEE v6. How can I make 24x7 execute multiple commands in
: one script?

Fri Jan 19, 2001 9:43 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.