How AS 400 sorting data?


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
How AS 400 sorting data?

Hi Gurus,
I have a requests to sort data based on AS 400 sorting order. below is example: the data is sorted by ascending order. could anybody explain how AS 400 sort data?

Code:
IMM00007
07918607
1242
423

# 2  
It may just be a simple numeric sort, similar to how Unix will too if you ask it to. Letters are seen as sorted before numbers, however zero (a zero value, even if 75 characters long) will be before them all. A shorter number of leading zeros is sorted before longer ones, of the same value.

You might illustrate it with this:-
Code:
printf "a
1
b
000000000000000000000000000000000000000
g
3
c
09
0"|sort -n


I hope that this helps,
Robin
# 4  
"collating sequence" is the key!
While most language (locale) settings in Unix are based on the ASCII sequence (numbers before characters), IBM seems to stick to the EBCDIC sequence (numbers after characters).
Maybe it is tunable? Search for "as400 how to set collating sequence"
These 2 Users Gave Thanks to MadeInGermany For This Post:
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Help with Data Sorting
pawannoel
Hi All, I have a long list made of 4 columns containing entries such as the following example: a b c d 0 0 0 0 1 2 1 2 2 5 3 4 3 8 4 6 4 10 9 8 5 15 8 10So the top row is the header and I need to arrange the data in a way as to...... UNIX for Dummies Questions & Answers
11
UNIX for Dummies Questions & Answers
Extract data from an AS/400 tape
mindmachine
Hello, we received an IBM data cartridge with some data on it. It is a backup of an old IBM AS400 machine that had gone for good some years ago. I am able to extract data from this tape by using dd on a LINUX system: Analysing the received file with forensic software (Xways, haven't tried Encase...... AIX
4
AIX
Sorting data
visuelz
Hello guys. I need help figuring this one out. It's probably really easy. Thanks in advance! I have a file say for example containing this: Rice Food Carrots Food Beans Food Plates Kitchen Fork Kitchen Knives Kitchen I need: Food Rice, Carrots, Beans Kitchen Plates, Fork,...... UNIX for Dummies Questions & Answers
7
UNIX for Dummies Questions & Answers
Sorting data from a to z
cosmologist
Hi, Let's say I have these 3 columns; NGC1234 6 9 SL899 4 1 NGC1075 8 3 SL709 5 2 And I want to sort the data according to the first column (from a to z) like having them as: NGC1075 8 3 NGC1234 6 9 SL709 5 2 SL899 4 1 Can that be done...... UNIX for Dummies Questions & Answers
2
UNIX for Dummies Questions & Answers
apache ErrorDocument 400 /cgi-bin/400.cgi
afadaghi
Hi All, Sorry if the question is trivial for you but, I am new to Apache (2.0.63) and am trying to figure out how to display my 400.cgi. Here is what I have in httpd.conf servername testing DocumentRoot "/usr/local/apache2/htdocs" ErrorDocument 400 /cgi-bin/badrequest-400.cgi Here is...... Solaris
0
Solaris