RE: sorting

[Angela Wawrzaszek <awawrzaszek@xxxxxxxxxxxxxxx>]

  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.

Angela Wawrzaszek
Nucor Steel Auburn
IT Department


-----Original Message-----
From: MacWheel99@aol.com [mailto:MacWheel99@aol.com]
Sent: Monday, October 29, 2001 1:20 PM
To: midrange-l@midrange.com
Subject: Re: sorting


Are you now using all permutations of 26 x 26 letters of the alphabet or not
even close?  If you are now only using the first few letters of the alphabet
& have 10 letters not in the chart, then assign them as substitutes for 0-9
in a 400 conversion program.

Can you increase the field size to AAA so you have 26 x 26 x 26
permutations?
 If you can eliminate digits from the coding system, then the EBCDIC ASCII
problem is history.

You might seek out copies of the collating sequences to see if there are any
characters that end up in the right sequence in both systems & thereby come
up with characters allowed to be used & not allowed to be used.

Alternatively can you split the field so that A & 1 are 2 fields sorted into
several reports which are printed or displayed one then another ... thus you
do the letters vs. numbers as separate sorts in the right sequence then
concatenate the results.

> We want the sort just the way it is on the as/400 because
>  this is out "size" field.  So when we sort items by their size code they
>  display nicely in alphabetic  order by their description.  But when we
push
>  it over to sql since the sort is not the same we now have something that
is
>  say 3" x3" (code = A1)  displaying before the 1" X 1" (code = AA) because
of
>  the difference in the sort.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
BPCS 405 CD Manager / Programmer @ Global Wire Technologies Incorporated
http://www.globalwiretechnologies.com = new name same quality wire
engineering company: fax # 812-424-6838
_______________________________________________
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.