Sort by bits SORT FIELDS=(133.1,.1,BI,A)

Craq Giegerich · Posted: Mon Mar 24, 2008 9:26 pm Post subject:

x'10' = b'00010000'
x'80' = b'10000000'
x'01' = b'00000001'

All of these have '0' in the second bit.

Maybe you should be sorting on 133,1,BI,A for the whole byte rather then just on one bit.

Frank Yaeger · Posted: Mon Mar 24, 2008 9:32 pm Post subject:

The only digit that matters here is the first one (e.g 8 in X'8000') since it contains the second bit:

0 = B'0000'
1 = B'0001'
8 = B'1000'

These all have 0 in the second bit so they all sort equally. (4 = B'0100' has a 1 in the second bit so it would sort after these others.)

If you have EQUALS in effect, the output records will be in the same order as the input records. If you have NOEQUALS in effect, the output records can be in any order.

You don't seem to understand what your SORT statement does. Maybe it's not the SORT statement you actually need. Perhaps you should tell me what you're trying to do so I can tell you how to do it.

arivazhagan_k · New User Joined: 05 Dec 2007 Posts: 36 Location: chennai

Frank Yaeger,
Craq,

Thanks for both of you .

arivazhagan_k · New User Joined: 05 Dec 2007 Posts: 36 Location: chennai

Before you post that ans i tried with same sample data "4 = B'0100' ".
i am wondering.
Now i got it .Thanks for your valuable response.