Sort numeric values stored in character format

faizm · New User Joined: 13 Apr 2012 Posts: 59 Location: India

Hi All,

Could you please help me in sorting using JCL. My requirement is, I have to sort the records based on the record numbers. The record numbers are presently in decreasing order like 30, 29,... upto 1. Now I want it o be in increasing order like 1,2,...30. Problem here is the record numbers are stored in char format.
I am using the below format in sysin of SORT JCL:

SORT FIELDS=(1,10,CH,A,755,5,CH,A) but it does sortin in following order
1
10
11
12
13
14
15
16
17
18
19
2
20
.
.

I also tried using SORT FIELDS=(1,10,CH,A,755,5,ZD,A), but of no use,

.

Can anyone help me urgently on this. Appreciate your responses. Thanks.

xknight · Posted: Tue Apr 17, 2012 4:57 pm

Hello,

Can you post the input file layout with the code tags.

Note: There is a code tab availiable, where you type the text, use it for better layout understanding.

faizm · New User Joined: 13 Apr 2012 Posts: 59 Location: India

Hi Naveen,

How to get that code tab; the layout of the file is FB, LRECL=1200, PS FILE.

xknight · Posted: Tue Apr 17, 2012 5:04 pm

Hello,

Copy the text of test input record & Paste it here, then look for tab Code beneath the Quick Reply, select the text which you want to tag it, then click the Code tab. Preview & Submit it.

Without seeing your test input record it is hard to assume.

faizm · New User Joined: 13 Apr 2012 Posts: 59 Location: India

Do you want me to put the whole text of 1200 length of input record?

xknight · Posted: Tue Apr 17, 2012 5:11 pm

Are you sorting the entire 1200 record length

faizm · New User Joined: 13 Apr 2012 Posts: 59 Location: India

David Robinson · Active User Joined: 21 Dec 2011 Posts: 199 Location: UK

I can see what the OP wants to do. The lower numbers, ie; <10, are represented as "1 ", "2 ", etc.

Thus when sorting, "10" comes before "2 ", which is not what is required.

Not sure what the solution is though. Sort is not my speciality.

faizm · New User Joined: 13 Apr 2012 Posts: 59 Location: India

Hi, Can anyone please help me on this. I need it to get it done asap. Thanks.

dbzTHEdinosauer · Posted: Tue Apr 17, 2012 5:37 pm

see what happens when you change the 'type' from CH to UFF?

gcicchet · Posted: Tue Apr 17, 2012 5:43 pm

Hi,

this is an example of what you need

faizm · New User Joined: 13 Apr 2012 Posts: 59 Location: India

Kudos, Indeed a perfect reply,I am very thankful to you. My issue is resolved.

. Thanks one again.

Thank you all for replying on the post.

Nic Clouston · Posted: Tue Apr 17, 2012 11:13 pm

Glad you got it working but it was NOT JCL that sorted it (your first post) but the sort program. Indeed, in the whole topic, the only JCL is in Gerry's solution.