Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
This topic is locked: you cannot edit posts or make replies. Selecting two copybooks of different ... Vignesh Sid COBOL Programming 8 Tue Sep 05, 2017 7:28 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us