Need help in generating dynamic sort card
Posted: Thu May 15, 2014 5:26 pm
Hi there,
Please help me generating the below given sort card dynamically. Need to get a date value from input file rather than hardcoding it.
Sort fields=copy
Omit cond=(53,8,ch,LT,C'20140515', AND,
88,3,CH,EQ,'AUT',AND,
143,3,CH,EQ,AUT)
other than the first condition, 2 conditions are direct hardcoding
I tried with Header, Build and trailer options in sort, but no luck in getting that
the sort card i tried so far,
//SYSIN DD *
OPTION COPY
OUTFIL REMOVECC,
HEADER1=(' SORT FIELDS=COPY '),
BUILD=(C' OMIT COND=(53,8,CH,LT,C''',2,8,C''',AND,
88,3,CH,EQ,C'''AUT,C''',AND,',),
I tried various combinations with the above given
Please do let me know if anything is not clear in this to help
Regards,
Damo
Please help me generating the below given sort card dynamically. Need to get a date value from input file rather than hardcoding it.
Sort fields=copy
Omit cond=(53,8,ch,LT,C'20140515', AND,
88,3,CH,EQ,'AUT',AND,
143,3,CH,EQ,AUT)
other than the first condition, 2 conditions are direct hardcoding
I tried with Header, Build and trailer options in sort, but no luck in getting that
the sort card i tried so far,
//SYSIN DD *
OPTION COPY
OUTFIL REMOVECC,
HEADER1=(' SORT FIELDS=COPY '),
BUILD=(C' OMIT COND=(53,8,CH,LT,C''',2,8,C''',AND,
88,3,CH,EQ,C'''AUT,C''',AND,',),
I tried various combinations with the above given
Please do let me know if anything is not clear in this to help
Regards,
Damo