Hi all,
I am having an issue with a sorting a file and maybe you can have some
helpful suggestions.
The input file has 87.231 records, with a RECFM(VB) and a LRECL(704). I
need to get all the records that meet these conditions:
INCLUDE COND=(8,4,CH,EQ,C'tool',OR,
7,7,CH,EQ,C'project',OR,
225,60,SS,EQ,C'"appname": "IBM')
Now, if I use only the first two INCLUDE statements:
SORT FIELDS=COPY
OPTION VLSHRT
INCLUDE COND=(8,4,CH,EQ,C'tool',OR,
7,7,CH,EQ,C'project')
I will have an output file with two records (the first and last record on
the file).
And if I use only the last INCLUDE statement:
SORT FIELDS=COPY
OPTION VLSHRT
INCLUDE COND=(225,60,SS,EQ,C'"appname": "IBM')
I will have an output file with 357 records.
However, when I use all the three statements,
SORT FIELDS=COPY
OPTION VLSHRT
INCLUDE COND=(8,4,CH,EQ,C'tool',OR,
7,7,CH,EQ,C'project',OR,
225,60,SS,EQ,C'"appname": "IBM')
I will get an output file with the exact same 357 records that I get when I
use only the last INCLUDE statement.
I tried using ICETOOL with the HEADER and TRAILER keywords to get the
records that match the last INCLUDE statement, keeping the first and last
file records, but ICETOOL DATASORT does not seems to support SORT
FIELDS=COPY
May be I am missing something obvious.
Your help will be, as always, truly appreciated
Regards
Jack
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
