Read related VSAM file records with part of the key



Unicenter CA-Easytrieve Plus Report Generator: CA's information retrieval and data management tool

Read related VSAM file records with part of the key

Postby shobvid » Fri Sep 18, 2009 6:48 pm

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
shobvid
 
Posts: 2
Joined: Thu Apr 03, 2008 2:15 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby BillyBoyo » Sun Jan 30, 2011 4:23 am

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to CA-Easytrieve

 


  • Related topics
    Replies
    Views
    Last post