How to suppress the warning messages in the DS director

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
arshi
Participant
Posts: 50
Joined: Wed Apr 18, 2007 5:12 am

How to suppress the warning messages in the DS director

Post by arshi »

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
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post by balajisr »

You can configure DB2 to supress this warning. Contact your DBA.
Post Reply