MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

why my substring search is failing?

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 372
Topics: 105
PostPosted: Tue Sep 02, 2008 10:09 am    Post subject: why my substring search is failing? Reply with quote
Hi,

I am using below sort card to search for string......it is failing !!!!

Code:

SYSIN :                                                           
  SORT FIELDS=COPY                                               
  INCLUDE COND=(7,6,SS,EQ,C'MTCZ9S,MPHTP7,MTWDFR,MTWDFV,MTZHFC,   
                            *                                     
  MTVZZB,MTWZ9Q,MTKQB3,MSQMZX,MQPZQG,MQWFBX,MQJQ97,MSJD02,MSJD03')
  *                                                               
WER251A  INCLUDE/OMIT INVALID SELF DEF TERM                       
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT                   
WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE                     


We are using SYNCSORT FOR Z/OS 1.2.2.1R. What is wrong here? Can you help me out please?

Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
callanand
Beginner


Joined: 12 Jun 2007
Posts: 23
Topics: 2
PostPosted: Tue Sep 02, 2008 11:20 am    Post subject: Reply with quote
Hi Mfuser,

Just as a matter of check. Are you coding the sort control cards from the 1st column in the SYSIN area. If yes please code it after 1st column.
Back to top
View user's profile Send private message
Sqlcode
Intermediate


Joined: 15 Dec 2006
Posts: 157
Topics: 38
PostPosted: Tue Sep 02, 2008 11:40 am    Post subject: Reply with quote
Try below mentioned card.

Code:
 
  SORT FIELDS=COPY                                               
  INCLUDE COND=(7,6,SS,EQ,C'MTCZ9S',OR,
                            7,6,SS,EQ,C'MPHTP7',OR,
                            7,6,SS,EQ,C'MTWDFR',OR,
                            7,6,SS,EQ,C'MTWDFV',OR,
                            7,6,SS,EQ,C'MTZHFC',OR,
                            7,6,SS,EQ,C'MTVZZB',OR,
                            7,6,SS,EQ,C'MTWZ9Q',OR,
                            7,6,SS,EQ,C'MTKQB3',OR,
                            7,6,SS,EQ,C'MSQMZX',OR,
                            7,6,SS,EQ,C'MSJD03',OR,
                            7,6,SS,EQ,C'MSJD02',OR,
                            7,6,SS,EQ,C'MQJQ97',OR,
                            7,6,SS,EQ,C'MQWFBX',OR,
                            7,6,SS,EQ,C'MQPZQG')


It worked for me. Below is the JCL i have used :


Code:
//STEP0100 EXEC PGM=SORT                       
//SORTIN   DD *                                 
AAAAAAMTCZ9S                                   
BBBBBBMPHTP7                                   
CCCCCCMTWDFR                                   
DDDDDDXTRCDF                                   
//SORTOUT  DD SYSOUT=*                         
//SYSIN    DD *                                 
 SORT FIELDS=COPY                               
 INCLUDE COND=(7,6,SS,EQ,C'MTCZ9S',OR,         
               7,6,SS,EQ,C'MPHTP7',OR,         
               7,6,SS,EQ,C'MTWDFR',OR,         
               7,6,SS,EQ,C'MTWDFV',OR,         
               7,6,SS,EQ,C'MTZHFC',OR,         
               7,6,SS,EQ,C'MTVZZB',OR,         
               7,6,SS,EQ,C'MTWZ9Q',OR,         
               7,6,SS,EQ,C'MTKQB3',OR,         
               7,6,SS,EQ,C'MSQMZX',OR,         
               7,6,SS,EQ,C'MSJD03',OR,         
               7,6,SS,EQ,C'MSJD02',OR,         
               7,6,SS,EQ,C'MQJQ97',OR,         
               7,6,SS,EQ,C'MQWFBX',OR,         
               7,6,SS,EQ,C'MQPZQG')             
/*                                             
//SYSOUT   DD SYSOUT=*                         


It seems like you are using SYNCSORT and I have DFSORT and I have less idea about SYNCSORT.
Back to top
View user's profile Send private message
Sqlcode
Intermediate


Joined: 15 Dec 2006
Posts: 157
Topics: 38
PostPosted: Tue Sep 02, 2008 11:41 am    Post subject: Reply with quote
Below is the SORTOUT after submitting above mentioned JCL

Code:
AAAAAAMTCZ9S                                                           
BBBBBBMPHTP7                                                           
CCCCCCMTWDFR
Back to top
View user's profile Send private message
Sqlcode
Intermediate


Joined: 15 Dec 2006
Posts: 157
Topics: 38
PostPosted: Tue Sep 02, 2008 11:46 am    Post subject: Reply with quote
If this doesn't work then try giving PARM='VLTESTI=1' and PARM='VLTESTI=2'.

Code:
//STEP001  EXEC PGM=SORT,PARM='VLTESTI=1'


or

Code:
//STEP001  EXEC PGM=SORT,PARM='VLTESTI=2'
Back to top
View user's profile Send private message
amargulies
Beginner


Joined: 10 Jan 2007
Posts: 123
Topics: 0
PostPosted: Tue Sep 02, 2008 1:43 pm    Post subject: Reply with quote
mf user,

Support for the simplified INCLUDE statement was included in SyncSort for z/OS 1.3.

As in Rajen's first post in this thread, you will need to specify each INCLUDE condition separated by OR's.
_________________
Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Back to top
View user's profile Send private message Send e-mail
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
PostPosted: Tue Sep 02, 2008 5:20 pm    Post subject: Reply with quote
For the record, the syntax shown in the first post is using invalid continuation. You can't continue a 'literal' in the middle using a comma-blank. It would work for DFSORT if continued correctly - run the literal up to position 71, put a non-blank (e.g. *) in 72, and continue on the next line. For example (I'm showing b for leading blank here to avoid confusion):

Code:

bbOPTION COPY
bbINCLUDE COND=(7,6,SS,EQ,C'MTCZ9S,MPHTP7,MTWDFR,MTWDFV,MTZHFC,MTVZZB,M*
bbbTWZ9Q,MTKQB3,MSQMZX,MQPZQG,MQWFBX,MQJQ97,MSJD02,MSJD03')

_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
mf_user
Intermediate


Joined: 01 Jun 2003
Posts: 372
Topics: 105
PostPosted: Thu Sep 04, 2008 4:13 am    Post subject: Thanks Frank. Reply with quote
Thanks a lot Frank. Yes.....it worked for me when I put '*' in 72nd position.

Bye.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group