DSXchange

Hi

Can I have Dependency on Stages within Datastage Job instead of Sequence ?

For instance, I wan to run update/insert query on two tables, but they have to be performed one after the other with same dataset. Do I have to go for the sequence for this functionality? Is there a way that I can implement this functionality within the same datastage job?

Many of the database connectors support multiple input links now. See if that will meet your needs.

What is your target database?

Mike

I prefer to use two jobs from a sequence. The first job identifies the inserts and updates, writes the inserts to a Data Set, and performs the updates. The second job performs the inserts.

I have chosen PL/SQL block in the options and executed the insert and then update sql.

I have tested it, and it works fine.

Do you think this could cause any unknown issues later down the road.