inesrt/update prblm with separate ODBC stage for same tabl
Posted: Wed Apr 06, 2005 2:43 am
Hi
I have to design a job in such a way that it does different transactions depends on the value of an input code on the same table.
Tx-----Tx--<Cond1>------Update
|___<Cond2>----{Update+Insert} **same transaction
|____<Cond3>---{Update+Insert} **same transaction
|____<Cond4>---Insert
While running the job only inserting values through<Cond4> and unable to update the table for the rows which satishfies the other conditions.
Director is diplaying two error codes for the unsuccessful updations... Those are
1.SQLSTATE=S1000, DBMS.CODE=-346
[DataStage][SQL Client][ODBC][DataDirect][ODBC Informix Wire Protocol driver][Informix]Could not update a row in the table.
2.SQLSTATE=S1000, DBMS.CODE=-244
[DataStage][SQL Client][ODBC][DataDirect][ODBC Informix Wire Protocol driver][Informix]Could not do a physical/* -order read to fetch next row.
Any idea why its happening? any solution for that?
Regards
Rubu
I have to design a job in such a way that it does different transactions depends on the value of an input code on the same table.
Tx-----Tx--<Cond1>------Update
|___<Cond2>----{Update+Insert} **same transaction
|____<Cond3>---{Update+Insert} **same transaction
|____<Cond4>---Insert
While running the job only inserting values through<Cond4> and unable to update the table for the rows which satishfies the other conditions.
Director is diplaying two error codes for the unsuccessful updations... Those are
1.SQLSTATE=S1000, DBMS.CODE=-346
[DataStage][SQL Client][ODBC][DataDirect][ODBC Informix Wire Protocol driver][Informix]Could not update a row in the table.
2.SQLSTATE=S1000, DBMS.CODE=-244
[DataStage][SQL Client][ODBC][DataDirect][ODBC Informix Wire Protocol driver][Informix]Could not do a physical/* -order read to fetch next row.
Any idea why its happening? any solution for that?
Regards
Rubu