Hi Heiko, Heiko Giesselmann [mailto:[EMAIL PROTECTED] > > I am having problems with a simple load command. I checked > the manuals > and I haven't been able to find the probably very basic and > simple problem. > > Table t1 was created using the following statement: > CREATE TABLE t1 ( c1 TIMESTAMP, c2 FIXED(10,3), c3 CHAR(255)) > > I am using a simple loader command file: > DATALOAD TABLE t1 > IGNORE DUPLICATES > c1 1 > c2 2 > c3 3 > INFILE 't1.dat' > TIMESTAMP 'YYYY-MM-DD HH:MM:SS' > > The data file t1.dat contains the following entries: > 2004-04-26 07:00:00,1.0,test1 > 2004-04-26 07:00:00,2.0,test2 > 2004-04-26 07:00:00,3.0,test3 > > Error during execution > -->-25319 > Missing data for specified column C2. > > Anybody any idea where I am making a mistake? > Run the command with specifying to use an 'empty' delimiter: DATALOAD TABLE t1 IGNORE DUPLICATES c1 1 c2 2 c3 3 INFILE 't1.dat' DELIMITER '' TIMESTAMP 'YYYY-MM-DD HH:MM:SS'
That should make the difference. Regards, Steffen -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
