Update Query using Oracle Enterprise Stage

[Vijay Kumar]

Hi,
Based on successful execution of a job I want to update an Oracle table.
So I want to execute an update query in a new job which will be executed after the First Job.
What is the best method to run the update query in a job(for all other jobs which reads data from Oracle I am using Oralce Enterprise stage)

Can I use the same Oracle Enterprise Stage to perform this task.
If yes, can any one explain how to do it?

Regards,
Vijay

[kool78]

Hi,
Based on successful execution of a job I want to update an Oracle table.
So I want to execute an update query in a new job which will be executed after the First Job.
What is the best method to run the update query in a job(for all other jobs which reads data from Oracle I am using Oralce Enterprise stage)

Can I use the same Oracle Enterprise Stage to perform this task.
If yes, can any one explain how to do it?

Regards,
Vijay

One method would be :

Create a procedure that implemets ur update functionality

and call tht procedure in Target OCI Stage in CLOSE COMMAND Property, so the procedure will be executed after completing all the operations on tht table.

[ray.wurlod]

Upsert mode, update first.