Hello Steffen, Thanks a lot for your reply.
It loaded all OK now :) I'm sorry i didnt tell you about the long, didnt think would make so much difference. I have to admit i don't fully understand how this solution with the longs work so i have to do some reading on this. Do i also have to do special things for other types? do you have a quick pointer to the docs where i can read about that? also, a last question, the longs in this case are primary kays. Can / Should i import them as text instead of longs? in fact, appart from binary data, is it correct to import the other things as text? Thanx again for your help. --- "Schildberg, Steffen" <[EMAIL PROTECTED]> wrote: > 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] > __________________________________ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
