Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Record not found

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
suraaj

New User


Joined: 16 Apr 2009
Posts: 69
Location: Canada

PostPosted: Tue Jul 16, 2013 6:04 pm    Post subject: Record not found
Reply with quote

Hi

I have opened a VSAM file in I-O mode and trying to check randomly if there is a record present based on a key. Its returning a file status of 23 which means record not found. But when I check manually with the key the record is present. I have checked the forum for suitable solution but was unable to find any solution. Please help.
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Tue Jul 16, 2013 6:17 pm    Post subject:
Reply with quote

What the 23 is telling you is that one (or more) of the bytes of the key that you are reading in your program do not match the key you found manually. Post (using the Code button) the hexadecimal display of the key you found manually, and the code you are using to read that key. If there were hexadecimal '00' values in the key, you might see it as having spaces and attempt to read it as such, but spaces are X'40', not X'00'.
Back to top
View user's profile Send private message
suraaj

New User


Joined: 16 Apr 2009
Posts: 69
Location: Canada

PostPosted: Tue Jul 16, 2013 7:03 pm    Post subject: Reply to: Record not found
Reply with quote

The key is X(19) with numeric data so the data is showing as digits. Its not packed.

Quote:
Post (using the Code button) the hexadecimal display of the key you found manually

Please advise if anything else was expected for the key.

I am reading a key value from another QSAM file and checking with the key in the VSAM. This key which I have from the QSAM I am moving to a key field and reading the file using the key. The command is simple READ after the movement.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Tue Jul 16, 2013 7:46 pm    Post subject:
Reply with quote

You may post what you want, although you have not yet posted a single thing I asked for.

The bottom line: a file status 23 code means you attempted to do a START or keyed READ of a file and the record you attempted to read is not found in the file. You may think you can find the record in the file manually, but the record you are finding in the file manually is NOT the record the program is reading -- period. As long as you refuse to accept that the program is not finding the key value in the file, you will not be able to proceed any further.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jul 16, 2013 8:50 pm    Post subject:
Reply with quote

Hello,

Keep in mind that IEBIBALL (eye-ball) is more forgiving than one's "own code" . . .

Check to make sure the value is in the proper positions in the record.
Back to top
View user's profile Send private message
Pete Wilson

Active User


Joined: 31 Dec 2009
Posts: 437
Location: London

PostPosted: Tue Jul 23, 2013 12:34 pm    Post subject:
Reply with quote

Have you defined the dataset with the correct KEYOFF value :¬#

I'm assuming it is a KSDS but you don't even specify if that is the case
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts sort with previous record anatol DFSORT/ICETOOL 9 Thu Oct 06, 2016 2:36 am
No new posts Get Record count in summary record fo... Atul Banke DFSORT/ICETOOL 21 Fri Sep 23, 2016 4:17 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts Using 'parm' to vary SORTOUT record v... Sysaron DFSORT/ICETOOL 13 Wed Sep 07, 2016 9:24 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us