Hi Bruno, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote: > > I have a textfile data.txt containing several lines of the format > > 20041001005136;12345678;AAT6A04100100512848821;[EMAIL PROTECTED] > > I want to load it via the loader > > loadercli -d TESTDB -u BRUNO,BRUNO -b loadit.txt > > // > CREATE TABLE tsttable > ( a CHAR(17) NOT NULL, > b CHAR(16) NOT NULL, > c CHAR(64) NOT NULL, > d CHAR(128) NOT NULL, > PRIMARY KEY (a) > ) > // > DATALOAD TABLE tsttable > a 1 > b 2 > c 3 > d 4 > INSTREAM 'data.txt' > COMPRESSED DELIMITER ';' > > But unfortunately I alwas get the following error code: > > -25362 > No data to load in datafile data.txt. > Successfully executed > You need to modify your command and declare the delimiter empty and the separator as ';' as follows: DATALOAD TABLE tsttable a 1 b 2 c 3 d 4 INSTREAM 'data.txt' COMPRESSED DELIMITER '' SEPARATOR ';'
That should do the job. 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]
