DSXchange

Posted: **Thu Dec 18, 2008 7:09 am**

Hi,

I am getting the following warning while running the job.

[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

Source : Text file
Target : DB2

Any one have the solution to overcome these warnings.

Regards,
Arshi

Posted: **Thu Dec 18, 2008 7:52 am**

DB2 does that. Make sure your update or delete actually has a row to update/delete before you fire it. Or use a message handler to demote the warning to informational.

Posted: **Thu Dec 18, 2008 3:44 pm**

Moderator: please move to server forum

Posted: **Thu Dec 18, 2008 10:42 pm**

Chulet,

How to demote the warning messages using message handler.

Regards,
Arshi

Posted: **Thu Dec 18, 2008 11:45 pm**

That 'message handler' advice is only valid for the Enterprise Edition, something I mentioned because you posted in the EE forum.