Please help, Informix and linux problem.
Graeme Barnett loaded an exported database into Informix SE 7.24 on Linux and got error 1205 (invalid month in date) and error 1766. He found it ran in US date mode. QueriX 4GL / Mehdi advised matching the DBDATE environment variable to the source system. Jonathan Leffler recommended DBDATE=DMY4/ and setting DBCENTURY to P. No confirmation of the result was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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>