warnings: No row was found for FETCH, UPDATE or DELETE

sreddy · Post by **sreddy** » Mon Aug 24, 2009 8:12 am

Hi

I have a job that is delete the records in the target table.

I am deleting two column records.

Table Name -- It is a Primary Key
Table SRKey -- It is a index key.

When i ran the job it is through warning.

No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000

What is the problem, any one can send the information.

miwinter · Post by **miwinter** » Mon Aug 24, 2009 8:31 am

Is that warning returned from the target table (i.e. where you are deleting)? It speaks for itself - it tells you that no rows matched the criterion given.

chulett · Post by **chulett** » Mon Aug 24, 2009 8:49 am

Best to pre-qualify your work with a lookup so you don't tell it to update or delete non-existent records. This is DB2, is it not?

sreddy · Post by **sreddy** » Mon Aug 24, 2009 12:09 pm

Thank you Hulett

My Target database is DB2.

chulett · Post by **chulett** » Mon Aug 24, 2009 12:15 pm

Thought that one would nag you like that. For better or for worse, Oracle doesn't care.