MVSFORUMS.com

Phantom

Hi,

Is there any way to sort data when the LRECL of the file is > 4092 bytes. When I was going thro' the doc in QW it said for CH, SORT supports a max of 4092 bytes. My input file is of LRECL 4350 and I want to sort on entire LRECL. How do I do this.

PS: I have Syncsort,

Thanks,
Phantom

kolusu · Posted: Wed Dec 15, 2004 1:14 pm Post subject:

Phantom,

4092 bytes is the limitation for sorting character data. However there is a way to overcome that , but right now I am swamped with work , so I will post a solution when I get a chance.

Thanks

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu

Phantom · Posted: Fri Dec 17, 2004 5:52 am Post subject:

Kolusu,

Did u get a chance to work on this ?

(PS: Did u see my private message ?)

Thanks,
Phantom

kolusu · Posted: Fri Dec 17, 2004 6:55 am Post subject:

phantom,

I could not work on this , I had an working example , but for some reason , I could not find it now.

Kolusu

PS: I have read your PM
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu

Phantom · Posted: Fri Dec 17, 2004 7:07 am Post subject:

Not a problem Kolusu. Please let me know if you get a chance to work on this.

kolusu · Posted: Fri Dec 17, 2004 8:37 am Post subject:

Phantom,

hmm JCL challanges? I don't recollect reading it May it is not delivered to me at all. can You send it once again. I set the limit to 10 messages for each inbox. once it is full then I will not be able to receive them.

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu

Phantom · Posted: Fri Dec 17, 2004 8:46 am Post subject:

Kolusu,

I don't see my message anywhere now Crying or Very sad

Its neither in the SENTBOX nor in the OUTBOX. Let me recollect what I sent you and I'll resend the message.!!!

Thanks,
Phantom

arvibala · Beginner Joined: 12 Feb 2008 Posts: 142 Topics: 67

Does this work now with ICETOOL .. I have a file with LRECL as 15000 and was looking for options to eliminate duplicates using SORT utility.

I got a document "User Guide for DFSORT PTFs UK90007 and UK90006" where it says under "Higher Ending Position for Sum Fields"

The maximum position for the end of a sum field has been raised to 32752.

Does this work for removing duplicates?
_________________
Arvind
"You can make a difference with your smile. Have that with you always"

Nic Clouston · Posted: Wed May 30, 2012 12:28 pm Post subject:

What happened when you experimented?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

Frank Yaeger · Posted: Wed May 30, 2012 12:43 pm Post subject:

The limit for the total length of the key is still 4K.

Various restrictions on where a field can start/end have been changed, but restrictions on the total length of the key have not been changed. For example:

arvibala · Beginner Joined: 12 Feb 2008 Posts: 142 Topics: 67

We use SYNCSORT ... so doesnt work .. I need to go for Cobol program with Sort Input Procedure and Output Procedure
_________________
Arvind
"You can make a difference with your smile. Have that with you always"