IBM Mainframe Forum

SYNCSORT FOR Z/OS 1.3.2.1NI
My records are 5560 chars long.
SORT FIELDS=(1,4093,CH,A)
SUM FIELDS=NONE

Above abends but value less than 4093 works.
The ON operand apparently has 1500 limit...

Anyway to get around these limitations?

appreciate any help!

Jon

Hello and welcome to the forum,

What is it that you are trying to accomplish? I have never seen a business reason to use a 4k sort key. . .

If you explain the actual requirement, someone may have a suggestion.

its crazy really but mostly bad design... just got loaned into the project helping out.

I want to compare yesterdays (Y) and todays (T) datasets and get rid of duplicates in them before producing files with what's in Y not in T, in T not in Y and in both.

Any column in a record can change so I really have to compare all 6650 chars of them. I have the control statements to do the compares up to 4K chars... I've tried several ways to extend beyond that but i get this;

WER164B 12K BYTES RESERVE REQUESTED, 1,004K BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER017A ERR IN DISP LENGTH VALUE
WER108I SORTIN : RECFM=FB ; LRECL= 6650; BLKSIZE= 26600

Searched but can't find anything on WER017A. Suggestions are welcomed.

Thanks

Hello Jon.

For fixed-length records, all control fields and the sum of their lengths cannot exceed 4092 bytes. When EQUALS is in effect, the number is reduced 4 bytes to 4088 bytes. EXTCOUNT also reduces the number by 4 bytes. Thus, if both EQUALS and EXTCOUNT are in effect, the number is reduced to 4084 bytes.

For variable-length records, all control fields must be located within the first 32750 bytes and the sum of their lengths cannot exceed 4084 bytes. When EQUALS is in effect, all control fields must be located within the first 32746 bytes and the sum of their lengths cannot exceed 4080 bytes.

Regards,

Richard/Alissa

Not the reply I was hoping for but thanks.

I could not find documentation on these limits, could you please send me a link I can refer the "smart" architects to and let them know they'll have to come up with a different/better strategy.

Greatly appreciated. BTW, great forum... very responsive... now a big fan!

Jon

The rules for specifying sort control fields can be found on page 2.201 in the SyncSort for z/OS 1.3.2 Programmer's Guide. If you need a copy of the manual, please contact me offline at alissa.margulies@syncsort.com and I would be happy to further assist you.