to sort the file by including only the records that are hav

mahi · New User Joined: 04 Apr 2006 Posts: 86 Location: Hyderabad

I have a flat file and I got a requirement to sort the file by including only the records that are having enddate less than 6/30/2006.

Here my problem is the date field is not in the date format..It is a Zoned Decimal field..(06302006 this is the date that is in the file)
How can I sort using that field?

Thank you,
Maheder

IQofaGerbil · Posted: Thu Aug 17, 2006 3:08 pm

assuming field starts at pos 1
then this include should work

mahi · New User Joined: 04 Apr 2006 Posts: 86 Location: Hyderabad

Thank you,
I will try this and let u know the results..

sril.krishy · Posted: Fri Aug 18, 2006 1:15 pm

Hi,
The other solution is ,,change the input file structure to have yyyymmdd and then directly use the LT option in SORT card.

Thank you
Krishy