I have a datastage job(job has one source UDB stage and one target UDB stage)which is used to delete records from a table when a condtion matches.(delete from table1 where <condition>)
When i run the job, i am getting FATAL error for the records in target table which doesnot match the delete condition.
Note: There are some records which matches the delete condition and they are deleted correctly.
Example:
source table count: 10
target table count:50
Among 10 records from source, 5 records satisfies the delete condition and other 5 records did not.
Now if i run the job its executed successfully, by giving below FATAL error for the 5 records which are not satisfied the delete condtion.
Code: Select all
Error in row #<row number>
Primary Error:
sqlcode=100, state=02000, message=[IBM][CLI Driver][DB2/AIX64] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000
Database : DB2
Can anyone faced the similar issue? Please reply me on how to over come this FATAL error msg.
Let me know if you need more info.
TIA,
Sri