How to execute a SQL script in Close Command Option

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
urahul
Participant
Posts: 9
Joined: Tue Dec 07, 2004 12:44 pm

How to execute a SQL script in Close Command Option

Post by urahul »

Hi,
How to execute a SQL script in Close Command Option in Oracle Enterprise Stage?

Thanks
Rahul
Top
Eric
Participant
Posts: 254
Joined: Mon Sep 29, 2003 4:35 am

Post by Eric »

I'm not sure that you can execute a script, but you can execute a single SQL statement (enter into the "Close Commadn field") which will be run once for each node in your configuration file.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”