Page 1 of 1

DataStage ODBC stage error

Posted: Wed Oct 10, 2007 8:42 pm
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

Posted: Wed Oct 10, 2007 9:02 pm
by chulett
Searching for your error turns this up, see if it helps:

viewtopic.php?t=99702

Posted: Thu Oct 11, 2007 9:41 pm
by yaminids
Thanks Craig