How to select the latest date record From VSAM file

rohanatl · New User Joined: 21 Oct 2005 Posts: 22

I have the following requirement.
Need to select the record with the latest date from a vsam file.
For Eg: I/p file is having the records like
Item Vendor Number Receipt Date
428 101 121225 (YYMMDD)
428 102 121223
In the above case i need to select the first record (with date 121225) since it is having the latest receipt date. Please help!

PeterHolland · Posted: Fri Dec 16, 2011 5:23 pm

If its a KSDS try an AIX on the receipt date. Probably you will have a lot of duplicates (maybe too much to build an aix).

dbzTHEdinosauer · Posted: Fri Dec 16, 2011 5:23 pm

if it is as simple as extracting the latest date for each item/vendor number,
there are many sort solutions available,
which would be easier/quicker to code and implement than a cobol module.

either way, you still need to sort the data before determining which record to keep.

Jose Mateo · Posted: Fri Dec 16, 2011 7:48 pm

Good day to all!

I agree with dbz.., you should sort the file in descending order by date that way you will be processing the latest date first.

gcicchet · Posted: Sat Dec 17, 2011 3:32 am

Hi,

the solutions provided are fine but I don't believe a sort is a must.

You can read and compare each record to the previous record and retain the record with the latest date.

Continue this process till the EOF and wrtite out the one with the latest date.

Gerry