Re: ESQL/C on SE-2.10 AND (Y2000 OR upgrade path) on SCO-3.2v5

On Mon, 14 Sep 1998, Joao Cardoso wrote: > This may look odd, but I am using SE version 2.10 on SCO-3.2v5. Yes, just a little archaic... > The C applications are several years old and still used. Now, with the > year 2000 problem I might have the problem of upgrading what is a death > product... Dead. Yes. I don't think 2.10 is supported at all, any more. > I am not currently using any Informix database either. > > Assuming that my C code is Y2000 aware, can anybody tell me if: > > - Version 2.10 is prone to year 2000 problems? I am using DBDATE=MDY4. It depends on your code. If you never tell the engine to convert a string with a 2-digit year in it, then you will have no problems, even after the year 2000 (at least, not with SE). On the other hand, if you do get the engine to convert a string with a 2-digit year in it, it will continue to add 1900 to the date, regardless of whether the year is 1998 or 2000 or 2030. Ditto with any ESQL/C or I4GL code. The DBCENTURY environment variable is all about how to handle 2-digit years, and that's all. > - There will be database incompatibilies? With what? > - I will have problems when trying to compile my .ec files with the > latest ESQL release? If so, is there any filter to acomplish the task? Normally, you won't run into many problems. There is no automatic tool that I know of to update the source code. > The products: > > INFORMIX-SQL Version 2.10.03K > INFORMIX ESQL Version 2.10.03K > > I appeciate any hints. I have already browsed the informix site, but > found no info other than saying that the last version is Y2000 aware. > > Thanks, > Joao > > -- > Joao Cardoso | e-mail: jcardoso@inescn.pt > INESC, R. Jose Falcao 110 | tel: + 351 2 2094322 > 4050 Porto, Portugal | fax: + 351 2 2008487 Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn