Re: Informix 4GL and year 2000 problems/ramblings

In article <58dol5$nte@cssun.mathcs.emory.edu>, billy@west.co.za ("Billy Wheeler") wrote: >On 8 Dec 96 at 0:52, Joel Schumacher wrote: > >> 1) First of all, I've heard various things about DBCENTURY. I've heard >> it only applies to the engine and not the tools. I'm not concerned >> with the engine, I'm concerned with dates input from 4GL screens. > >Now I'm confused. How is DBCENTURY going to do anything if it only >gets used by the engine? My current understanding of DBCENTURY is >that you can set it to be a specific century or the century closest >to the system date and it works for all tools. Hm, maybe not! :-) > >> I've heard DBCENTURY has no effect to any of the 4GL versions. >> Is this correct? > >It might be true, although I'm sure they'll fix that soon enough... DBCENTURY has no effect on 4GL. Last we heard Informix are planning to include it late in 1998 (really -- I'm not making this up!) Everything Joel says is right on the money. You (currently) have to go with 4 digit years and hope the users don't key in 2 digit years, or write a date-mangling routine which you call in the AFTER FIELD clause of any date fields. Or not use 4GL for data entry. ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.5 June 96 Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/ New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/pub/informix/