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
Below are the results of calling loadercli: > loadercli -d CR -b "t1.ctl" -E 400 -u user,pwd Loader Server Protocol File: 'd:\programme\maxdb\data\wrk\loader.prt'
User USER connected to database TEST on local host. DATALOAD TABLE t1 IGNORE DUPLICATES c1 1 c2 2 c3 3 INFILE 't1.dat' TIMESTAMP 'YYYY-MM-DD HH:MM:SS' Error during execution -->-25319 Missing data for specified column C2.
1 error(s) during execution of command file 't1.ctl'. ---> See log file(s) for more information.
Anybody any idea where I am making a mistake?
Thanks, Heiko
-------------------------------------------------------------- This mail has been inspected by Webwasher - leading technology for E-mail and Web Security.
Webwasher - keeping your Web clean! --------------------------------------------------------------
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
