> --- Urspr�ngliche Nachricht --- > Von: Frank Schimmelpfennig <[EMAIL PROTECTED]> > An: [email protected] > Betreff: Loader: -25301 Invalid input for date or time column: ? > Datum: Tue, 7 Jun 2005 16:36:42 +0200 > > Hi all, > > I have a compressed textfile gsa.dat containing several lines of the > format > (pls. see below) > > gsa.dat: > 1;1;1;268435455;05.05.2005;?;? > 2;2;132192484;139999999;05.05.2005;?;? > 3;2;233982849;234999999;05.05.2005;?;? > > When I want to load the data with the Loader utility. Unfortunately I get > a > -25301 error (command and system message pls. below). What is wrong with > my > date specification? Is there someone who can give a hint? > > Thanks in advance! > > DATALOAD TABLE gsa_tab > UPDATE DUPLICATES > gsa_id 1 > dty_id 2 > min_snr 3 > max_snr 4 > start_date 5 > end_date 6 > description 7 > INSTREAM 'gsa.dat' > COMPRESSED > DELIMITER '' > SEPARATOR ';' > DATE EUR > Error during execution > -->-25301 > Invalid input for date or time column: ?
MaxDB does not consider "?" a valid date. I wouldn't consider it a valid date either... robert > > Defined maximum number of errors (1) reached > > kind regards > Frank > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- Weitersagen: GMX DSL-Flatrates mit Tempo-Garantie! Ab 4,99 Euro/Monat: http://www.gmx.net/de/go/dsl -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
