MVSFORUMS.com

[flatearther]

Quick question - I have a file with a sequence number which is numeric and unfortunately left-justified (with trailing spaces).

Is it possible to sort using this field as the sort key (descending)?

Specifying the field as CH or BI doesn't work, for instance:

Seq No
---------
11
1234
111111

won't sort to
111111
1234
11

because of the left-justification.
Any ideas?

[flatearther]

Just to clarify - I want to sort on the numerical values of the field (descending) so I want the sort outcome to be:

Seq No
---------
111111
1234
11

but the left justification is messing this up:

Seq No
---------
1234
111111
11

[Ram]

If you have DFSort installed, use the justify feature.

e.g.

OPTION COPY
OUTREC FIELDS=(1,30,JFY=(SHIFT=RIGHT))

Once its right justified, you can sort it accordingly.

[kolusu]

flatearther,

Ram has the right idea but his example shows OUTREC which is executed AFTER sorting.

So use the following DFSORT JCL to get the desired results

[flatearther]

That's works great! Thanks a lot for your help.

[Frank Yaeger]

You don't need the INREC or OUTREC statement. Sorting with the UFF format will handle this without any need for JFY. So the DFSORT job would just be: