Hi! I have the following requirement:
input file1:
123456789-123456789-123456789-123456789-123456789-----> column
A T1234567 01/10
B T1234561 01/10
A T1234562 01/10
B T1234563 01/10
A T1234564 01/10
B T1234565 01/10
A T1234566 01/10
A T1234567 01/10
input file2:
123456789-123456789-123456789-123456789-123456789-----> column
A T1234567 01/11
A T1234561 01/11
A T1234562 01/11
B T1234563 01/11
A T1234564 01/11
B T1234565 01/11
A T1234566 01/11
A T1234567 01/11
Total 10 input files in the same format as above - the date will remain the same for all records in a file, but differ from file to file as given in the example
All files are FB, Sequential files. Files could have 1000s of records.
In my output file i need the Date and Total Number of records in each input file, only records marked as A at pos 1 need to be considered in the Total.
INCLUDE COND=(1,1,CH,EQ,C'A') - filter-out unneeded rows on entry
SORT FIELDS=(12,5,CH,A) - resort on date value, to be sure
OUTFIL REMOVECC,NODETAIL, - eliminate all input records from output
SECTIONS=(12,5, - on each date change:
TRAILER3=(1,1,X, insert one "report line" for the same date
12,5,X, for the specific date
COUNT,ZD,LENGTH=8)) print record count
