Need help on SORT
Posted: Wed Apr 04, 2018 9:58 pm
Hi All,
I need a help from you to sort data from an input file based on the reference date present in it from column 55 to 62. My requirement is to sort out data which has been last referenced within 3 months.
Please note that the reference date is present in the format YY/DD/MM (e.g: 18/03/14 etc).
I have tried the below sort code but it works only when the date format is YYYY/MM/DD. But my requirement is to sort data from the input file which is in the format YY/DD/MM. So can anyone please help me
--------------------------------------------------------------------------------
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(55,8,CH,GT,DATE1(-)-90)
/*
--------------------------------------------------------------------------------[/img]
I need a help from you to sort data from an input file based on the reference date present in it from column 55 to 62. My requirement is to sort out data which has been last referenced within 3 months.
Please note that the reference date is present in the format YY/DD/MM (e.g: 18/03/14 etc).
I have tried the below sort code but it works only when the date format is YYYY/MM/DD. But my requirement is to sort data from the input file which is in the format YY/DD/MM. So can anyone please help me
--------------------------------------------------------------------------------
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(55,8,CH,GT,DATE1(-)-90)
/*
--------------------------------------------------------------------------------[/img]