Re: DBLOAD and dates

From: lachlan Dunlop <lach@lach.net> > >I'm having a hell of a time trying to load some data from mysql to >informix. > >It has to do with dates. I have DBDATE set to "MDY4/". When I try to >run dbload I get invalid month? > >Here is a data example: > >In INSERT statement number 1 of raw data file loan.txt. >Row number 1 is bad. >1|Mansion on the Hill|Hill 1, lot 24, Ralph's >Addition|1000000.0000|1000000.0000 >|400000.0000|12/01/1915|8.5000|08/22/2000|1|1|09/01/2000|500.0000|0|N|N|0|N|N|4| > >2|1|1|1|2|3|1|3|3|3|2|0|N|1| > >Invalid month in date Perhaps your column alignment is out and you're actually trying to load an int or a char into a date? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

That was it! I have |1|1| where dates belong. Thanks Lach Obnoxio The Clown wrote: > From: lachlan Dunlop <lach@lach.net> > > > >I'm having a hell of a time trying to load some data from mysql to > >informix. > > > >It has to do with dates. I have DBDATE set to "MDY4/". When I try to > >run dbload I get invalid month? > > > >Here is a data example: > > > >In INSERT statement number 1 of raw data file loan.txt. > >Row number 1 is bad. > >1|Mansion on the Hill|Hill 1, lot 24, Ralph's > >Addition|1000000.0000|1000000.0000 > >|400000.0000|12/01/1915|8.5000|08/22/2000|1|1|09/01/2000|500.0000|0|N|N|0|N|N|4| > > > >2|1|1|1|2|3|1|3|3|3|2|0|N|1| > > > >Invalid month in date > > Perhaps your column alignment is out and you're actually trying to load an > int or a char into a date? > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com