Remedy for error WER251A



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

Remedy for error WER251A

Postby ranga_subham » Thu Nov 19, 2009 6:27 pm

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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Remedy for error WER251A

 

Re: Remedy for error WER251A

Postby Alissa Margulies » Thu Nov 19, 2009 9:55 pm

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
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 1 time

Re: Remedy for error WER251A

Postby Alissa Margulies » Fri Nov 20, 2009 11:03 pm

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).
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 1 time

Re: Remedy for error WER251A

Postby ranga_subham » Tue Nov 24, 2009 5:41 pm

Hi,

Thanks a lot. This is very nice trick.

How many such OR can be clubbed with SS?

Please advise.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Remedy for error WER251A

Postby Alissa Margulies » Tue Nov 24, 2009 9:18 pm

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.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 1 time

Re: Remedy for error WER251A

Postby ranga_subham » Thu Nov 26, 2009 10:14 pm

Thanks for the important info...... :D
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post