Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Substring be scanned via syncsort

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
jammy_27

New User


Joined: 06 Aug 2009
Posts: 17
Location: USA

PostPosted: Thu Sep 24, 2015 8:50 pm    Post subject: Substring be scanned via syncsort
Reply with quote

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
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Thu Sep 24, 2015 10:02 pm    Post subject: Reply to: substring question
Reply with quote

You need to look up the syntax of the INCLUDE where it relates to SS and discover exactly what to do in exactly that circumstance.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am
No new posts ICETOOL/SYNCSORT - SYSPRINT output nartcr DFSORT/ICETOOL 17 Wed Oct 05, 2016 10:46 pm
No new posts Syncsort version supporting FINDREP c... juares castro SYNCSORT 9 Tue Aug 09, 2016 6:54 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us