MVSFORUMS.com

binduvnair · Beginner Joined: 07 Jan 2003 Posts: 16 Topics: 8

Hi,

Could you please let me know how I can get the last record in the VSAM file directly.
The scenario is as follows:
Have a CICS banking application, where account no: is created by adding one to the previous account no:. THe data is not stored in the DB2 tables but in VSAM. So when i need to create the new account no: , is there a way for me to reach the last record of the vsam directly and then add one to it?

Thanks and Regards,
Bindu

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

Bindu,

Check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=4151&highlight=read+last+record+vsam+directly

kolusu · Posted: Wed Apr 18, 2007 5:11 am Post subject:

binduvnair,

You can start from the end of the data set by specifying a complete key of high-values(X'FF') characters on the STARTBR command. This points to the last record in the file ready for a backward browse. Once you have positioned your pointer you can issue a READPREV command. With READPREV command records are read sequentially backward from the current position.

Hope this helps...

Cheers

Kolusu

vkphani,

The link you pointed shows batch utility solutions instead of a programatic solution

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Sreejith · Posted: Wed Apr 18, 2007 5:11 am Post subject:

Not 100% sure about this and don't have any VSAM file here set up to test this.
But try this

Move high-values to vsam-key
start file key greater than or eaqual to

read file prev

Sreejith · Posted: Wed Apr 18, 2007 5:13 am Post subject:

and of course Kolusu beat me by seconds

Posted: Wed Apr 18, 2007 10:11 am Post subject