DataStage ODBC stage error

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
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

DataStage ODBC stage error

Post by yaminids »

Hello friends,

I got the following error after the completion of the job. The job has 3 ODBC stages and a Transformer stage

ODBC-1====>ODBC-2====>Transformer====>ODBC-3

ODBC-1 deletes the records from a table
ODBC-2 selects data from a db and populates a table mentioned in ODBC-3

Error: DSD.StageStatus: Wave sequence error, resource "VENDORORD_STG.DeleteRecsActual4.input_DelRecs3" has CUR.WAVE.NUM=25, was looking for wave 2
DataStage Phantom Finished

Did anyone face this error before?

Any help would be highly appreciated
Yamini
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Searching for your error turns this up, see if it helps:

viewtopic.php?t=99702
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

Post by yaminids »

Thanks Craig
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”