Ooppss...
want to know something...
can i use ExecCommand in the job sequencer to execute a sql file which can truncate the tables
Search found 33 matches
- Sun Jun 24, 2007 10:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job to trucate tables
- Replies: 14
- Views: 5711
- Sun Jun 24, 2007 10:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job to trucate tables
- Replies: 14
- Views: 5711
- Sun Jun 24, 2007 9:54 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job to trucate tables
- Replies: 14
- Views: 5711
Job to trucate tables
Hi, I pretty new to datastage. So the question I am posting might be very silly. I have a scenario where in I have to clear all the tables before inserting. I know there is a option like truncate and insert. But what I want to know is, if there is some other solution to this problem. Can I have a jo...