DSXchange

Posted: **Fri Jun 10, 2005 12:35 pm**

Hi,
This is an urgent requirement.
I need to design a datastage job which will process 10,000 records every half hour. My source is Db2 and my target is oracle.
Problem is once a record is loaded into oracle, in the source DB2 there is a column value Y which has to be changed to P and if there is a error in loading it has to changed to E. How to specify this condition.
Iam stuck with job design
Please help me
Thanks
Bye

Posted: **Fri Jun 10, 2005 3:46 pm**

You can use that as a parameter, and assign the value through a afterjob routine.
This afterjob routine will check the status of your job, and based on the status it will set the value of that parameter to p or e.

HTH

Posted: **Fri Jun 10, 2005 4:53 pm**

I'd probably write all of your functional keys from the source DB2 table to a flat file during the run, along with a 'P' or an 'E' based on the success or failure of your Oracle work.

A second job could then take the file of keys, source those and perform updates on those records back in DB2 with the stored flag.

Posted: **Fri Jun 10, 2005 6:28 pm**

Please don't tag your posts here as urgent. This is an all-volunteer operation; folks post as and when they can.

If you want urgent responses, sign up for premium support from your support provider, with a KPI of (say) response within an hour. You will then learn something of the true cost of "urgent".

DSXchange

Change the Column after that particular row is processed

Change the Column after that particular row is processed

Not urgent