Hi Frank, Frank Schimmelpfennig [mailto:[EMAIL PROTECTED] wrote: > > 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? > > > 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: ? > The question sign acts a NULL value specification. You should change your load command as follows:
DATALOAD TABLE gsa_tab UPDATE DUPLICATES gsa_id 1 dty_id 2 min_snr 3 max_snr 4 start_date 5 end_date 6 DEFAULT NULL description 7 DEFAULT NULL INSTREAM 'gsa.dat' COMPRESSED DELIMITER '' SEPARATOR ';' DATE EUR and it'll do. This way you inform the Loader about the fact that it has to interpret a question sign (the default NULL value specification in data files) for fields 6 and 7 as a NULL value rather than a real value. Regards, Steffen -- Steffen Schildberg MaxDB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
