warning while running the job

arshi · Post by **arshi** » 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

chulett · Post by **chulett** » 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.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 18, 2008 3:44 pm

Moderator: please move to server forum

arshi · Post by **arshi** » Thu Dec 18, 2008 10:42 pm

Chulet,

How to demote the warning messages using message handler.

Regards,
Arshi

chulett · Post by **chulett** » 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.