RE: sorting

[Angela Wawrzaszek <awawrzaszek@xxxxxxxxxxxxxxx>]

But that would still involve redoing the way out size codes are.  ie.  AA =
1 X 1   A1 = 3 X 3  so even though it sorts by ascii if we were to force
that then it will not look correct    showing the 3 X 3 first so we would
need to change what shows on each.   So no matter what it will be a change
on our codes.

Angela Wawrzaszek
Nucor Steel Auburn
IT Department


-----Original Message-----
From: Peter Dow [mailto:pcdow@yahoo.com]
Sent: Monday, October 29, 2001 4:32 PM
To: midrange-l@midrange.com
Subject: Re: sorting


Hi Angela,

On the AS400 you could simply create a logical file the ALTSEQ(QSYS/QASCII)
file-level keyword and all your key fields will be sorted as if they were
ASCII encoded.  Then your sales department can still use 0-9 or even
lowercase a-z in their sort field and it will sort the same as the SQL
server.

hth,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

From: "Angela Wawrzaszek" <awawrzaszek@nucorauburn.com>
>   We will have to look at recoding our 2 position text field.  Once they
cme
> up with the plan I can do the mass change for them.  We do not use all 26
> X26 right now.  We would not be able to change the field to 3 positions as
> this is a software package,  not a home grown application or file.



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.