MVSFORUMS.com

lacoe1 · Beginner Joined: 24 Feb 2005 Posts: 33 Topics: 17

I have an input file with the following
BA
00
TX
C3
C1
C2
C3
This needs to be sorted as
00
BA
C1
C2
C3
TX
Any suggestions? We are using SORT, but the results are not what we would like to see.

kolusu · Posted: Thu Feb 24, 2005 3:23 pm Post subject:

lacoe1,

So you want numerics to be first followed by alphabetic values? If so then the following JCL will give you the desired results. The format AC will sort according to the ASCII sequence which has the numbers before the letters.

lacoe1 · Beginner Joined: 24 Feb 2005 Posts: 33 Topics: 17

Kolusu, thanks for the response. Just 1 problem, the results gave
00
BA
C3
C1
C2
C3
TX
The C3 did not move after C2, rather it stayed right after BA.

kolusu · Posted: Thu Feb 24, 2005 3:45 pm Post subject:

lacoe1,

The Job Posted by me gives the correct results.

lacoe1 · Beginner Joined: 24 Feb 2005 Posts: 33 Topics: 17

You are right. It works. My starting position in the file was incorrect.

Thank you.

dtf · Posted: Thu Feb 24, 2005 4:01 pm Post subject:

I think there is also a sort control parameter ALTSEQ which can be used to assign any collating sequence that you want.

DTF
________
Yamaha YZ125 history

Frank Yaeger · Posted: Thu Feb 24, 2005 4:37 pm Post subject:

DTF,

You could collate '0'-'9' before 'A' like this:

dtf · Posted: Thu Feb 24, 2005 10:47 pm Post subject:

I was only pointing out that ALTSEQ gives one the flexability to change the collating sequence in any way you want........
________
Motorcycle tires

Frank Yaeger · Posted: Fri Feb 25, 2005 11:09 am Post subject:

"to change the any collating sequence that you want" is a little overstated, but yes, ALTSEQ does give you some flexibility to change the collating positions of characters in the 256-byte EBCDIC table.
_________________
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