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
 
Reading bulk of records from VSAM.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Reading bulk of records from VSAM.
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: 3158
Location: Tucson AZ

PostPosted: Wed Nov 29, 2006 5:39 pm    Post subject:
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    Post subject:
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    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 Merging records, but not all the time prino DFSORT/ICETOOL 0 Sat Feb 17, 2018 4:20 pm
No new posts Need all records with high key kalidasvs SYNCSORT 13 Fri Feb 09, 2018 10:38 pm
No new posts Why is SORT rearranging records that ... cschablow DFSORT/ICETOOL 4 Wed Jan 24, 2018 10:14 pm
No new posts Where to get sample for processing RM... vice_versa PL/I & Assembler 2 Tue Jan 16, 2018 2:03 pm
No new posts VSAM dataset not found abdulrafi JCL & VSAM 5 Fri Jan 12, 2018 11:19 am

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