Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Sorting a record of Length 32k

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
kwelkid

New User


Joined: 21 Mar 2006
Posts: 1

PostPosted: Fri Jun 30, 2006 5:21 pm    Post subject: Sorting a record of Length 32k
Reply with quote

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
View user's profile Send private message

IQofaGerbil

Active User


Joined: 05 May 2006
Posts: 183
Location: Scotland

PostPosted: Fri Jun 30, 2006 7:10 pm    Post subject: Re: Sorting a record of Length 32k
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri Jun 30, 2006 8:53 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Alain Benveniste

New User


Joined: 14 Feb 2005
Posts: 88

PostPosted: Mon Jul 03, 2006 10:27 pm    Post subject:
Reply with quote

Frank,

Well I remember i posted something about this somewhere.
I need to look back in my archives.

Alain
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 2 Sun Nov 06, 2016 8:11 pm
No new posts Joinkeys operation when key1 and key2... Susanta DFSORT/ICETOOL 5 Wed Nov 02, 2016 5:35 pm
No new posts Efficient sorting chandracdac DFSORT/ICETOOL 5 Sat Oct 22, 2016 3:23 am
No new posts sort with previous record anatol DFSORT/ICETOOL 9 Thu Oct 06, 2016 2:36 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us