Update Problem
Posted: Fri Jun 06, 2003 8:48 am
Hi All
I have two jobs to load a table.The first job loads the data from master to the target.The second job updates the data from child to the target.But when the second job finds no data to be updated it gets aborted with the error .
[DataStage][SQL Client][ODBC][IBM][CLI Driver][DB2/6000] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000
Does the datastage job gets aborted if it does not find anything to update?If this is the case, then how should I implement the update strategy?
Regards
Shiva
Shivakumar
I have two jobs to load a table.The first job loads the data from master to the target.The second job updates the data from child to the target.But when the second job finds no data to be updated it gets aborted with the error .
[DataStage][SQL Client][ODBC][IBM][CLI Driver][DB2/6000] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000
Does the datastage job gets aborted if it does not find anything to update?If this is the case, then how should I implement the update strategy?
Regards
Shiva
Shivakumar