Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 8154
Location: East Dubuque, Illinois, USA

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: 8154
Location: East Dubuque, Illinois, USA

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: 446
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 Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us