IBM Mainframe Forum

by **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.

by **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

by **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:

Select all

//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:

Select all

//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).

by **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.

by **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.

by **ranga_subham** » Thu Nov 26, 2009 10:14 pm

Thanks for the important info......

IBM Mainframe Forum

Remedy for error WER251A

Remedy for error WER251A

Re: Remedy for error WER251A

Re: Remedy for error WER251A

Re: Remedy for error WER251A

Re: Remedy for error WER251A

Re: Remedy for error WER251A