Page 1 of 1

Read related VSAM file records with part of the key

PostPosted: Fri Sep 18, 2009 6:48 pm
by shobvid
Hi all,

I need help in reading a VSAM file as following

1. VSAM has a key length of 20 bytes (depart no - 10 bytes, employee no - 10 bytes)
2. Now I have the depart no value and have to get all the records for that department and get the employee numbers
3. Since depart no is part of the key, can I read the records with GT key by passing low values to the employee number and get all the records for that department.

Please suggest, meanwhile Iam going to try working on to read the vsam file.

Thanks for the help in advance.

VVV

Re: Read related VSAM file records with part of the key

PostPosted: Sun Jan 30, 2011 4:23 am
by BillyBoyo
shobvid wrote:Hi all,

I need help in reading a VSAM file as following

1. VSAM has a key length of 20 bytes (depart no - 10 bytes, employee no - 10 bytes)
2. Now I have the depart no value and have to get all the records for that department and get the employee numbers
3. Since depart no is part of the key, can I read the records with GT key by passing low values to the employee number and get all the records for that department.

Please suggest, meanwhile Iam going to try working on to read the vsam file.

Thanks for the help in advance.

VVV


Do a POINT with the key from your 3. Then do GET until the depart no changes.