IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Reading bulk of records from VSAM.


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gokuldass

New User


Joined: 18 Mar 2005
Posts: 48
Location: india

PostPosted: Wed Nov 29, 2006 5:10 pm
Reply with quote

Hi all,

I just want to know on how to read a bulk of records from vsam file.

For example..

let us consider the following 8 records in the VSAM file sorted on key position 0 to 11.

Gokuldass00 seniorsoftware
Gokuldass01 H/wengineer
Gokuldass02 Eng
Gokuldass03 qualityanalyst
Gokuldass04 softwareeng
Harishkum00 DME
Harishkum01 manager
Jackdavids00 PM


Now, I want to read the records with keys starting from Gokuldass00 to Gokuldass04 at a single read into a buffer area. May be using StartBr command.

But my problem is, I know only first 9 positions of my key in my program & I don't know the sequence number appended with it.

Now I want to do a bulk read with this 9 character key which is not unique also. So, is there any chance to add the low and high value while reading the file.

Keep in mind that I don't want to do Sequential read in my program which costs more for me.

Please, let me know how to do it.

Thanks in Advance.
Regards,
Gokul
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Wed Nov 29, 2006 5:39 pm
Reply with quote

do you want to read those first 5 records or really start reading after them?
Back to top
View user's profile Send private message
gokuldass

New User


Joined: 18 Mar 2005
Posts: 48
Location: india

PostPosted: Thu Nov 30, 2006 9:53 am
Reply with quote

Hi,

The input record sequence may be different.

I am not always interested to read the first set of records..

It may come in any order.

For example.. Let us consider the name Zahirkhan00 to Zahirkhan10 which comes at the bottom while sorting..


Regards,
Gokul
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
Search our Forums:

Back to Top