Run the SQL script file

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
bkumar103
Participant
Posts: 214
Joined: Wed Jul 25, 2007 2:29 am
Location: Chennai

Run the SQL script file

Post by bkumar103 »

The requirement is like this.
We have a teradata SQL script. Which contains a SELECT statament.
We need to have a job which runs this sql script. Is there any stage which can execute the teradata SQL script.


Thanks in advance,
Birendra
Top
Mayur Dongaonkar
Participant
Posts: 20
Joined: Mon Dec 11, 2006 10:57 am
Location: Pune

Post by Mayur Dongaonkar »

In db2 we have db2 -tvf scriptname. But I am not sure about teradata.
Mayur Dongaonkar.
Top
Post Reply

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