TO delete data from tables before execution of sequence job

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Manu1
Participant
Posts: 36
Joined: Mon Aug 31, 2009 5:51 am
Location: Hyderabad

TO delete data from tables before execution of sequence job

Post by Manu1 »

Sequence job performs the table loads.These tables have a parent child relationship.First the Parent table is loaded and then after a sequence the child table will be loaded.
My requirement is to delete data from all the tables before I start the sequence job.Here we need to delete data from the child table first and then the Parent table
Which is the best method to delete data from tables which have parent child relationship.
Manu
Datastage Devoloper
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Create jobs to delete data from the two tables.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply