DSXchange

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.

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.

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?

Thank you Hulett

My Target database is DB2.

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