MVSFORUMS.com

mainhead · Beginner Joined: 07 Feb 2006 Posts: 26 Topics: 11

I have online screen where it abends while retriving from Table, comes out with 100

ROW NOT FOUND FOR FETCH, UPDATE OR DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE

, could any one please give information how to handle 100 abend

Thanks,

kolusu · Posted: Wed Feb 08, 2006 12:51 pm Post subject:

mainhead,

Is this a trick question? Why not check the sql code immediately after the execuetion of the query?

Bithead · Posted: Wed Feb 08, 2006 1:24 pm Post subject:

...sigh!

raam_narayan · Beginner Joined: 28 Apr 2006 Posts: 12 Topics: 2

Hi,

Are u trying to to do a fetch in the Test Table or in the Production region.. Because if u r trying this in the Test environment u can modify the data as per ur convenience in the table and u can match the WHERE condition in ur SQL... Basically this SQLCODE arises when the table is EMpty or when it does not matches the WHERE clause... Try to modify the date in the Test table as per ur convenience and submit ur JOB or run it in the XPEDITOR so that u can find out what's happening... Pls revert back if u need more clarifications on this..

Thanks & Regards,
V.Ram NArayan

mainhead · Beginner Joined: 07 Feb 2006 Posts: 26 Topics: 11

its in live (production) screen