View previous topic :: View next topic |
Author |
Message |
Nabanita Das Beginner
Joined: 09 Nov 2005 Posts: 33 Topics: 10
|
Posted: Thu Jun 14, 2007 9:55 am Post subject: Limit of COUNT variable in SORT |
|
|
Hi all,
I have observed that count variable in SYNCSORT or DFSORT can only hold upto 8 digit number. Is there a way to get the count which can accomodate more than 8 digit?
Nabanita |
|
Back to top |
|
 |
dbzTHEdinosauer Supermod
Joined: 20 Oct 2006 Posts: 1411 Topics: 26 Location: germany
|
|
Back to top |
|
 |
Phantom Data Mgmt Moderator

Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Thu Jun 14, 2007 10:38 am Post subject: |
|
|
Nabanita,
There are 2 operators COUNT and COUNT15 supported by both Syncsort and Dfsort (Depending on the version of sort product). COUNT15 handles upto 15 digits. Will this be okay for you (15 digits).
Thanks,
Phantom |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Thu Jun 14, 2007 10:39 am Post subject: |
|
|
Nabanita Das,
Look up the parm COUNT15 which allows a right-justified 15-digit field with leading zeros suppressed. Both DFSORT and Syncsort support this parm
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
Frank Yaeger Sort Forum Moderator

Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
|
Posted: Thu Jun 14, 2007 11:53 am Post subject: |
|
|
For DFSORT:
COUNT - 8 digits, right justified with leading zeros suppressed
COUNT15 - 15 digits, right justified with leading zeros suppressed
COUNT=(edit) - 15 digit count edited as specified, e.g. COUNT=(M26,LENGTH=13)
COUNT=(to) - 15 digit count converted as specified, e.g. COUNT=(TO=ZD,LENGTH=12) _________________ 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 |
|
 |
Nabanita Das Beginner
Joined: 09 Nov 2005 Posts: 33 Topics: 10
|
Posted: Thu Jun 14, 2007 11:30 pm Post subject: |
|
|
Wonderful! Thanks to everybody, I got what I wanted. Sorry I forgot to mention that I have syncsort in my shop. I mentioned about DFSORT also as I got to see some sample using DFSORT and giving count only as 8 digit number.
Thanks
Nabanita |
|
Back to top |
|
 |
|
|