I have a KSDS key as below
The records in the VSAM file can have effective date as future date. On that date I need to read the record with the new effective date and all other previous dates I need to read the old record. I know I can do it thru Generic and read next. But is there any other efficient way of doing it?
Joined: 06 Jun 2008 Posts: 8165 Location: East Dubuque, Illinois, USA
Build an alternate index on effective date.
Reading the key generic means, by the way, that you have to specify at least part of the branch to do the read -- generic key reads go from left to right. If your key is branch, dealer, effective date then you cannot read all keys that have a given effective date with a generic read.