Re: MIDRANGE-L Digest V4 #613

[Jon.Paris@xxxxxx]

 >> Could a disaster happen?  Absolutely if proper planning is not done.

I think it would need a lot of planning, not to mention database changes.
Since dates on the database are stored as a 4 byte day count (I won't say
Lilian 'cos it'll only start a debate again <g>), if the window changes
then all of a sudden what was a valid date will now blow up because it
falls outside the window for a two digit format.  Since one of the big
features of dates is guaranteed integrity I would say this is a biggie.  Of
course you were asking for trouble by specifying a two digit format to
begin with, but you know that if the option is available it will have been
used.

Would it not be a safer option to introduce new date formats that are tied
to the appropriate sysval rather than effectively changing the meaning of
existing formats?

Jon Paris
Jon.Paris@e400.com

www.e400.com - A new wave of iSeries and AS/400 Education

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---