Hi Matt, found the problem. matt rogers [mailto:[EMAIL PROTECTED] wrote: > > C:\maxdb\programs\bin> > C:\maxdb\programs\bin>loadercli -u DBA,dba -d crap1 > Loader Server Protocol File: > 'c:\maxdb\data\wrk\loader.prt' > > User DBA connected to database CRAP1 on local host. > loadercli> > DATALOAD TABLE dba.contacts contactid 1 surename 2 > INFILE 'c:\maxdb\tests\contac > ts.csv' SEPARATOR ';' > ERR -25502 > Error opening file '1': wrong file or device name. > I'm pretty sure the first column (contactid) of your table is defined as a long column, right? I was at least able to reproduce the error here with this assumption. To load longs (as short they ever might be) it is necessary to specify a long data file. Your command should look like this
DATALOAD TABLE dba.contacts contactid 1 surename 2 INFILE 'c:\maxdb\tests\contacts.csv' SEPARATOR ';' LONGFILE contactid '<your_long_file_name>' The corresponding content of contacts.csv then must be for your data "1-1";"Smith" "2-2";"Robinson" "3-3";"Cage" The data in your longfile then must be 123 Well, actually the Loader should report a different error message (from that reporting in your case) saying that there is the longfile info missing. Obviously this got lost 'in space' in the current version. We'll correct that asap. Sorry for any inconvenience. If more problems arise with the Loader let me know. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
