View previous topic :: View next topic
|
Author |
Message |
kwelkid
New User
Joined: 21 Mar 2006 Posts: 1
|
|
|
|
Hi,
We are having a file with record length of 32K. These records are to be sorted on fields of length exceeding 4K. We are using DFSORT and the limit is 4K.
Following is the sort statement that is being used
SORT FIELDS=(12,4000,CH,A,4012,90,CH,A)
The message obtained is as follows
ICE189A 0 BLOCKSET REQUIRED BUT COULD NOT BE USED - REASON CODE IS 63
Is there any other method available to sort these huge files |
|
Back to top |
|
|
IQofaGerbil
Active User
Joined: 05 May 2006 Posts: 183 Location: Scotland
|
|
|
|
Reason code 63 for ICE189A
Too many control fields were specified.
Do you have any other statements in your job? maybe you should show more. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
We are having a file with record length of 32K. These records are to be sorted on fields of length exceeding 4K. We tried using DFSORT but the limit is 4K. |
The limit is actually 4092 bytes (or 4088 bytes when EQUALS is in effect). The record length of 32K is irrelevant.
Quote: |
Please let us know if there is any alternative method of sorting a file with 32k LRECL. |
DFSORT can sort a file with 32K LRECL. However, it cannot sort with more than 4092 bytes. |
|
Back to top |
|
|
Alain Benveniste
New User
Joined: 14 Feb 2005 Posts: 88
|
|
|
|
Frank,
Well I remember i posted something about this somewhere.
I need to look back in my archives.
Alain |
|
Back to top |
|
|
|