Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
arshi
Participant
Posts: 50 Joined: Wed Apr 18, 2007 5:12 am
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Dec 18, 2008 3:44 pm
Moderator: please move to server forum
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
arshi
Participant
Posts: 50 Joined: Wed Apr 18, 2007 5:12 am
Post
by arshi » Thu Dec 18, 2008 10:42 pm
Chulet,
How to demote the warning messages using message handler.
Regards,
Arshi
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers