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 Record Not found in AlX but record re... mukun264 COBOL Programming 4 Fri Mar 24, 2017 9:28 am
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm
No new posts Writing on to GSAM variable length rohanthengal JCL & VSAM 6 Fri Mar 03, 2017 7:46 pm
No new posts To Merge mutliple records into a sing... anandgbe DFSORT/ICETOOL 6 Wed Feb 22, 2017 8:49 am


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