View previous topic :: View next topic |
Author |
Message |
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Wed Dec 15, 2004 11:01 am Post subject: Problem with SORT when LRECL > 4092 Bytes |
|
|
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 |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
|
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
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
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 |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
|
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
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
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.
Code: |
I have read your PM
|
The one on "JCL challenges" ? Its still showing in my OUTBOX (for the past 3 days). Is there a problem with the server ?
Thanks,
Phantom |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
|
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
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Fri Dec 17, 2004 8:46 am Post subject: |
|
|
Kolusu,
I don't see my message anywhere now Its neither in the SENTBOX nor in the OUTBOX. Let me recollect what I sent you and I'll resend the message.!!!
Thanks,
Phantom |
|
Back to top |
|
|
arvibala Beginner
Joined: 12 Feb 2008 Posts: 142 Topics: 67
|
Posted: Wed May 30, 2012 8:04 am Post subject: |
|
|
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" |
|
Back to top |
|
|
Nic Clouston Advanced
Joined: 01 Feb 2007 Posts: 1075 Topics: 7 Location: At Home
|
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. |
|
Back to top |
|
|
Frank Yaeger Sort Forum Moderator
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
|
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:
Code: |
SORT FIELDS=(26001,4000,CH,A)
|
is valid, but:
Code: |
SORT FIELDS=(26001,5000,CH,A)
|
is not valid. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
Back to top |
|
|
arvibala Beginner
Joined: 12 Feb 2008 Posts: 142 Topics: 67
|
Posted: Thu May 31, 2012 5:31 am Post subject: |
|
|
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" |
|
Back to top |
|
|
|
|