Search found 33 matches

by dsdeveloper123
Sun Jun 24, 2007 10:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job to trucate tables
Replies: 14
Views: 5711

Ooppss...
want to know something...
can i use ExecCommand in the job sequencer to execute a sql file which can truncate the tables
by dsdeveloper123
Sun Jun 24, 2007 10:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job to trucate tables
Replies: 14
Views: 5711

Thank you...
I m calling a user defined sql file which will delete all the tables I use.
by dsdeveloper123
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...