Multiple conditions on single INCLUDE



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Multiple conditions on single INCLUDE

Postby hariharan_bk » Wed Sep 10, 2014 6:20 pm

Hi All,

Need advise on howto use INCLUDE COND when multiple conditions are to be met.
I have verified many threads regarding this and have tried many combinations, yet i am stuck to get proper syntax. Please advise.

//SYSIN DD *                                           
  SORT FIELDS=COPY                                     
  INCLUDE COND=(2,7,CH,EQ,C'IGD107I'                   
          ,AND,55,10,CH,EQ,C'ROLLED IN,'               
          ,AND,                                       
      (9,29,CH,EQ,C'BST7SYST.APB.MD.TRIGGER.FINAL',OR,
       9,29,CH,EQ,C'BST7SYST.APB.MD.CONFIRM.FINAL',OR,
       9,25,CH,EQ,C'BST7SYST.APB.MD.DATARDW.G'))       
/*                                                     


Following is the error details from spool
SYSIN :                                                             
  SORT FIELDS=COPY                                                   
  INCLUDE COND=(2,7,CH,EQ,C'IGD107I',AND,55,10,CH,EQ,C'ROLLED IN,'   
                                                                  * 
               ,AND,                                                 
               *                                                     
      (9,29,CH,EQ,C'BST7SYST.APB.MD.TRIGGER.FINAL',OR,               
      *                                                             
       9,29,CH,EQ,C'BST7SYST.APB.MD.CONFIRM.FINAL',OR,               
       *                                                             
       9,25,CH,EQ,C'BST7SYST.APB.MD.DATARDW.G'))                     
       *                                                             
WER251A  INCLUDE/OMIT INVALID LOGICAL OPERATOR                       
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT                     
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT                     
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT                     
WER275A  NO KEYWORDS FOUND ON CONTROL STATEMENT                     
Many Thanks,
Harry
hariharan_bk
 
Posts: 70
Joined: Thu Mar 29, 2012 11:13 am
Has thanked: 5 times
Been thanked: 0 time

Re: Multiple conditions on single INCLUDE

 

Re: Multiple conditions on single INCLUDE

Postby BillyBoyo » Wed Sep 10, 2014 6:55 pm

That output is not from those SORT cards.

You have



Which is not valid, and:

  INCLUDE COND=(2,7,CH,EQ,C'IGD107I' 


and

          ,AND,55,10,CH,EQ,C'ROLLED IN,' 


You need a trailing comma or colon for a simple continuation, and no leading comma or colon on the continued line.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Multiple conditions on single INCLUDE

Postby NicC » Thu Sep 11, 2014 1:01 am

Pray tell...why is his coded in the JCL part of the forum and not one of the sort forums? Moved.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post