Sort Numeric field with spaces

ismail.hasan · New User Joined: 28 Mar 2007 Posts: 21 Location: India

Hi
My Input values are like this
1
5
3
203
100
20
1002
2
200
10

After sort using syncsort data type CH length (1,4)

What i am getting is
1
10
100
1002
2
20
200
203
3
5

But I need output file in the below format:

1
2
3
5
10
20
100
200
203
1002

Seeking your guidance.
Thanks is Advance.
Ismail

expat · Posted: Mon Dec 22, 2008 7:27 pm

Numeric fields need to be justified to get the correct results from a sort process.

Where are these numbers supplied from ?

ismail.hasan · New User Joined: 28 Mar 2007 Posts: 21 Location: India

From a Input file which is fetched from the database.
using cast functionality.

Arun Raj · Posted: Mon Dec 22, 2008 7:42 pm

ismail.hasan,

You CAN do this in sort. BTW, what is your source table column definition for this? Isn't it possible to do an ORDER by while fetching these values.

ismail.hasan · New User Joined: 28 Mar 2007 Posts: 21 Location: India

No I am using union. So group by or order by are not possible for the all the fetch in a single strecth

Arun Raj · Posted: Mon Dec 22, 2008 8:26 pm

gcicchet · Posted: Tue Dec 23, 2008 6:42 am

Hi,

you can try this

Arun Raj · Posted: Tue Dec 23, 2008 9:05 am

Gerry,

But if the same could be achieved in SQL itself, should n't he be going for that?

gcicchet · Posted: Tue Dec 23, 2008 9:29 am

Hi Arun,

my answer was based on the the subject line