Page 1 of 1

WER251A INCLUDE/OMIT INVALID LOGICAL OPERATOR

PostPosted: Sat Jun 16, 2012 4:13 pm
by viki
Hi All,

When i submitted the job with below condition by using SORT utility, it was throwing an error like 'INCLUDE/OMIT INVALID LOGICAL OPERATOR'

Condition:
SYSIN :
  OPTION COPY                                                           
     INCLUDE COND=((361,5,CH,EQ,C'ABCDE',AND,29,6,CH,EQ,C'KALASK',AND, 
                   657,5,CH,EQ,C'12958',AND,648,2,CH,EQ,C'ST'),OR,     
                   (361,6,CH,EQ,C'NANADI',AND,29,7,CH,EQ,C'BALAKRI',AND,
                   670,20,CH,EQ,C'00000000008019001487'))               
                   *                                                   
WER251A  INCLUDE/OMIT INVALID LOGICAL OPERATOR                         
WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE


I have tried with removing last condition it was working fine.But the requirement to get the last record also.

Can anyone please help me on this.

Thanks,
Viki.

Re: WER251A INCLUDE/OMIT INVALID LOGICAL OPERATOR

PostPosted: Sat Jun 16, 2012 7:04 pm
by Robert Sample
It looks like you're awfully close to the end of the line. Why not split the code up like this to avoid that?
  OPTION COPY                                                           
     INCLUDE COND=((361,5,CH,EQ,C'ABCDE',AND,
                   29,6,CH,EQ,C'KALASK',AND,
                   657,5,CH,EQ,C'12958',AND,
                   648,2,CH,EQ,C'ST'),OR,     
                   (361,6,CH,EQ,C'NANADI',AND,
                   29,7,CH,EQ,C'BALAKRI',AND,
                   670,20,CH,EQ,C'00000000008019001487'))

Re: WER251A INCLUDE/OMIT INVALID LOGICAL OPERATOR

PostPosted: Tue Jun 19, 2012 7:25 am
by viki
Robert: It's working now.Thank you so much.

Re: WER251A INCLUDE/OMIT INVALID LOGICAL OPERATOR

PostPosted: Tue Jun 19, 2012 7:38 am
by Robert Sample
Glad to hear it's working.