Reading KSDS with Date field as one of the Key field

rajithmuthan · New User Joined: 04 Jun 2007 Posts: 2 Location: USA

Hi,
I have a KSDS key as below
Branch
Dealer
effective date

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?

Rajith Bellimuthan

Robert Sample · Posted: Tue Jul 28, 2009 3:15 am

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.