Page 1 of 1

Remedy for error WER251A

PostPosted: Thu Nov 19, 2009 6:27 pm
by ranga_subham
Hi,

Trying to use SS with INCLUDE Condition and getting the below error:

WER251A INCLUDE/OMIT INVALID SELF DEF TERM


INCLUDE COND=(24,6,SS,EQ,C'186786,193674,201674,214663,258450,258455')


Please help.

Thanks.

Re: Remedy for error WER251A

PostPosted: Thu Nov 19, 2009 9:55 pm
by Alissa Margulies
Hello ranga_subham.

Please send the complete job listing as a text attachment to me offline at alissa.margulies@syncsort.com and I would be happy to look into this issue for you.

Regards,
Alissa

Re: Remedy for error WER251A

PostPosted: Fri Nov 20, 2009 11:03 pm
by Alissa Margulies
For substring comparisons, character and hex strings have a limit of 256 bytes in length. Based on the listing you sent me, you have exceeded this limit. I would recommend modifying your jobstream to use the following INCLUDE statements instead:
//SYSIN DD *                                                         
  SORT FIELDS=COPY                                                   
  INCLUDE COND=(24,6,CH,EQ,L(C'186786',C'193674',C'201674',C'214663',
        C'258450',C'258455',C'258462',C'258463',C'258475',C'258477',
        C'258478',C'258482',C'258486',C'258487',C'258500',C'258502',
        C'258506',C'258508',C'258484',C'258510',C'258511',C'258512',
        C'258514',C'258518',C'258521',C'258523',C'258547',C'258549',
        C'258554',C'258559',C'258564',C'258566',C'258569',C'258570',
        C'258581',C'258582',C'258583',C'258586',C'258593',C'258596',
        C'259604',C'258582'))   
Please note, this simplified INCLUDE statement requires SyncSort for z/OS 1.3. It is not supported in earlier releases of the sort.

If you are running an earlier release of SyncSort, then you can use the following control statements:
//SYSIN DD *                                                           
 SORT FIELDS=COPY                                                       
 INCLUDE COND=((24,6,SS,EQ,C'186786,193674,201674,214663,258450,258455,*
               258462,258463,258475,258477,258478,258482,258486,258487,*
               258500,258502,258506,258508,258484,258510,258511,       *
               258512'),OR,                                             
               (24,6,SS,EQ,C'258514,258518,258521,258523,258547,258549,*
               258554,258559,258564,258566,258569,258570,258581,258582,*
               258583,258586,258593,258596,259604,258582'))             
/*                                                                     
(In this example, the SORT and INCLUDE statements begin in column 2).

Re: Remedy for error WER251A

PostPosted: Tue Nov 24, 2009 5:41 pm
by ranga_subham
Hi,

Thanks a lot. This is very nice trick.

How many such OR can be clubbed with SS?

Please advise.

Re: Remedy for error WER251A

PostPosted: Tue Nov 24, 2009 9:18 pm
by Alissa Margulies
With each SS, you can have up to 256 characters before you need to use OR. The number of OR's is dependent upon the amount of below the line virtual storage available. If resources were limited and you were to encounter a WER002A EXCESS CARDS critical error, then you could attempt to pass a higher MINCORE value as a runtime PARM.

Re: Remedy for error WER251A

PostPosted: Thu Nov 26, 2009 10:14 pm
by ranga_subham
Thanks for the important info...... :D