Please help, Informix and linux problem.

I'm trying to use informix SE v 7.24 to import a previously exported database. I exported the previous database using SCO Opern Server 5, and Informix V 7. However, that should make no difference. The problem that I'm having is that it gives me an invalid month in date when I try and load any of the data into the newly created database. error 1205 and error 1766 cannot open olutil.iem. Please advise, Cheers, Graeme

> I'm trying to use informix SE v 7.24 to import a previously exported > database. I exported the previous database using SCO Opern Server 5, and > Informix V 7. However, that should make no difference. > > The problem that I'm having is that it gives me an invalid month in date > when I try and load any of the data into the newly created database. > error 1205 and error 1766 cannot open olutil.iem. > I've managed to work out that the version I've downloaded is working in US date mode. How do you make this work in DDMMYY format. Ta Graeme

Graeme Barnett wrote: > I'm trying to use informix SE v 7.24 to import a previously exported > database. I exported the previous database using SCO Opern Server 5, and > Informix V 7. However, that should make no difference. > > The problem that I'm having is that it gives me an invalid month in date > when I try and load any of the data into the newly created database. > error 1205 and error 1766 cannot open olutil.iem. > > Please advise, > > Cheers, > > Graeme check your environment DBDATE (echo $DBDATE) it should be in the same format as the environment you exported the database from. i.e. DBDATE=dmy4/ is different to DBDATE=mdy4/ and so on.-- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web) For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------

Graeme Barnett wrote: > > I'm trying to use informix SE v 7.24 to import a previously exported > > database. I exported the previous database using SCO Opern Server 5, and > > Informix V 7. However, that should make no difference. > > > > The problem that I'm having is that it gives me an invalid month in date > > when I try and load any of the data into the newly created database. > > error 1205 and error 1766 cannot open olutil.iem. > > > > I've managed to work out that the version I've downloaded is working in US > date mode. How do you make this work in DDMMYY format. Try to avoid 2-digit years -- they lead to confusion. Set DBDATE=DMY4/; it will handle 2-digit and 4-digit years. Worry about the correct setting for DBCENTURY; I suspect that your data will benefit from the value 'P', meaning all dates occurred prior to today's date. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN #include <disclaimer.h>