DataStage 6.0: Job does not do 2 post activities

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
bbetl
Premium Member
Premium Member
Posts: 1
Joined: Thu Apr 26, 2007 5:03 pm
Location: Dallas, Texas
Contact:

DataStage 6.0: Job does not do 2 post activities

Post by bbetl »

I am trying to do 2 activities after a job runs successfully. I am putting those 2 statements in the After tab of the oracle stage. One is an Update statement and other one is calling a stored procedure. Though I am trying to update a different table after my main job is done. The SQL statement runs fine in Toad. It is kind of something below:

UPDATE DA.XXXTable
SET LAST_UPDATE_DT = TRUNC(SYSDATE)
WHERE TABLE_NAME = 'MYXXXTable';
call #pMySchema#.SomeStoredProcedure();

Though the job finishes successfully,in the log error shows up. See below

MyTableDB.MYXXXTable: ORA-00900: invalid SQL statement

Can I do 2 activities in the After tab?
Any response is appreciated. Thanks.
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No. But you could build the two into a single stored procedure.
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