IBM Mainframe Forum

Hi All
I have requirement to compare the header date with the date of every record of that file.
if header-date =< record date + 60 days then include this record to my output file.
Can you plz give me a sort control card.
I/P file is FB, header date is present in 1-8 bytes and record date is at 60-68th byte.

What I can think of is a 2 step process. In the first step create a symname file where you extract the date from the header record and in the second step, have an include cond referencing the parameter on the symname file.

Hope this helps.

Thanks,
Ashwin.

Identify the header with WHEN=GROUP, PUSH the date, adjust the date for the comparison you want with WHEN=INIT then use INCLUDE=/OMIT= on OUTFIL.

Hi Billy,
Can you plz provide me link if in past you explained the same requirement.
I am just a fresher for JCL n SORT. so not getting your high level hint.

Hi Ashwin,
I am not getting your hint, can you please give a bit details or an example for the same.

input file :
header date
seqnum name rollno address record date

2 output files:
1. having header date - record date <= 60
2.having header date - record date >60
output files are fb

Get yourself the DFSORT Getting Started Guide.



Run that with your data, and look at the SORTOUT. You will see, on all records, the date from the header is at position 81.