Control Table in datastage?

A_SUSHMA · Post by **A_SUSHMA** » Fri Mar 28, 2014 3:01 am

Hi All,

what is Control table in data stage and how it works ?

If possible Please explain me with example..

ray.wurlod · Post by **ray.wurlod** » Fri Mar 28, 2014 4:05 am

There isn't one.

If there is, it's something YOUR developers/designers have implemented. It is they, therefore, who need to do the explaining.

A_SUSHMA · Post by **A_SUSHMA** » Sat Mar 29, 2014 5:57 am

Hi All,

I have two jobs,In this I need to execute second job from First job. Means to Execute one job from other job.

Please explain me how can i do in datastage...

chulett · Post by **chulett** » Sat Mar 29, 2014 7:41 am

Still not a control table.

If you need to run the two jobs in a particular order one after the other, that's what a Sequence job would let you do. If you need one job to run another, you'll need to be more explicit as to what exactly that means.

One time thing? Technically you can use dsjob from the After Job area of the first job but you're better off using a Sequence for that. Need to run the second job once for every row the first one processes, perhaps even passing row data from the first job to the second as parameters? That's what DSUtilityRunJob is for.