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
 
Sort a file of 8000 character length

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

New User


Joined: 09 Jun 2005
Posts: 10

PostPosted: Tue Apr 15, 2008 7:48 pm    Post subject: Sort a file of 8000 character length
Reply with quote

We have an input file of over 8000 characters. Out of this, we have a field of length 7980 which needs to be sorted before processing.
But we came to know that sort is capable of handling at a maximum of 4092 characters, irrespective of the length of the record.

Can anyone please suggest us an alternate way to get this sort done?

Naga
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Tue Apr 15, 2008 8:44 pm    Post subject:
Reply with quote

If you can fit the total number of records into the max size of a seqnum, sort it several times, first with the first 4092 bytes of the key while appending a seqnum, then again with the seqnum and the rest of the key.....
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 15, 2008 10:01 pm    Post subject:
Reply with quote

Hello,

One way to do what you want is to sort the file 2 times.

The first sort is on positions 4001-8000.

The second sort (using the output from the first sort) is on positons 1-4000. In this second sort, specify OPTION EQUALS to preserve the original sequence of the records within the new sort key. If EQUALS is in effect, the duplicate records are kept in their original order.
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 sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Garbage on output file Hervey Martinez SYNCSORT 4 Wed Sep 27, 2017 12:50 am

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