Re: Year 2000 and Collating Sequence

At 02:49 AM 5/13/97 +0000, you wrote:
>Steve Raisor wrote:
>> 
>> The idea of changing the collating sequence was suggested by someone in
>> our office as a way of correcting the sort problems for the year 2000
>> for two digit dates.  I believe this to be a dangerous option and would
>> appreciate hearing further opinions!!
>> 
>> Thanks in advance!!
>> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>Steve,
>   I would be curious to hear why this would be dangerous.  Why would 
>using an alternate collating sequence for a date field cause a 
>problem...?  How would you use it.?  Where would you use it.?
>
>Bob Williams
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
As a solution it works. The concerncould be that alternate collating
sequence  might be rarely used  (an exception situation if you will) That
being the case  it could easily be overlooked in future maintenance efforts
and  the new work might not include  Alt. Col. Seq.  increasing the  odds
of failure.

Glenn
___________________________________________________
Glenn Ericson,          Phoenix Consulting                      
P O Box 701164   East Elmhurst NY 11370-3164 USA                            
Ph. 718 898 9805         Fx. 718 446 1150
AS/400 & Year 2000- - Solutions  © 1997copyright,  all rights reserved
____________________________________________________


 
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *