jammy_27
New User
Joined: 06 Aug 2009 Posts: 17 Location: USA
|
|
|
|
Can a range of substring be scanned via syncsort on every record?
My requirement is as below :-
I have a variable block input file
VB, LRECL = 25889
I am looking for texts anywhere from V200 thru V300 on every record in that file
I Could write the sort for one text - example V208 and it works fine. I used the PARM='VLTESTI=2'
SORT FIELDS=COPY
INCLUDE COND=(5,25885,SS,EQ,C'V208')
But the records can have multiple occurrences for any number between V200 to V300. If any of these texts appear , that record should be included.
I tried using the below but it doesnt work. let me know if i am missing anything.
SORT FIELDS=COPY
INCLUDE COND=(5,25885,SS,GE,C'V200',AND,
5,25885,SS,LE,C'V300')
SORT FIELDS=COPY
INCLUDE COND=(5,25885,SS,GE,C'V200',AND,
*
5,25885,SS,LE,C'V299')
WER813I INSTALLATION OPTIONS IN MFX LOAD LIBRARY WILL BE USED
WER251A INCLUDE/OMIT INVALID COND
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE |
|