I have a requirement mentioned below:
KEEP Record if one of the following condition is met:
- REC DATE > YESTERDAY'S DATE
- REC DATE = YESTERDAY'S DATE AND
REC has values equal to zero in column 11-16
- REC DATE = YESTERDAY'S DATE AND
REC has 'N' in column 388 and 'C' in col 390
Input file has date in col 1-5 in Packed format
Input and output both are 400 byte record in packed format. i wrote the below sort card for it but it is not giving the desired result.
Code:
OPTION COPY
INCLUDE COND=(1,5,PD,GT,TARGET,
OR,1,5,PD,EQ,TARGET,
AND,11,6,PD,EQ,ZEROES,
OR,1,5,PD,EQ,TARGET,
AND,388,1,CH,NE,C'N',
AND,390,1,CH,NE,C'C')
i am using TARGET as the label for the yesterday's date using different code .
Could anyone let me know whether the code is correct according to the req. i have mentioned