Hello Elke, Thanks. Now it's better.
The previous error was : "sql statement too long". loadercli tried to execute the file as one sql statement. Now with the command : loadercli -u x,x -d $SID -b file.sql -E 20 -cs ';' Everything is ok. Regards, AB ----Message d'origine---- >De: "Zabach, Elke" <[EMAIL PROTECTED]> >A: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, >Sujet: RE: loading data (was :: sql statements) >Date: Mon, 8 Mar 2004 10:38:16 +0100 > >[EMAIL PROTECTED] wrote >> >> Hello, >> >> I'd like to know how can I load a huge amount of sql >> statements from a file . >> >> I'm trying with : >> >> -dbmcli >> >> -xsql >> >> -loadercli > > The loader is THE client for loading huge amount of data > >> -sqlcli >> >> >> witch is the best suitable for this task? >> >> here is a sample of the data file : >> >> -- >> >> create table ABContact ( >> contactId varchar(100) not null primary key, >> userId varchar(100) not null, >> firstName varchar(100), >> lastName varchar(100), >> emailAddress varchar(100), >> homeStreet varchar(100), >> homeCity varchar(100), >> homeState varchar(100), >> homeZip varchar(100), >> homeCountry varchar(100), >> homePhone varchar(100), >> homeFax varchar(100), >> homeCell varchar(100), >> businessCompany varchar(100), >> businessStreet varchar(100), >> businessCity varchar(100), >> businessState varchar(100), >> businessZip varchar(100), >> businessCountry varchar(100), >> businessPhone varchar(100), >> businessFax varchar(100), >> businessCell varchar(100), >> birthday timestamp, >> instantMessenger varchar(100), >> website varchar(100) >> ); >> >> >> -- >> >> >> I tried with the command : /opt/sdb/programs/bin/loadercli -u >> x,x -d $SID -b file.sql -E 20 but with no success. >> > >What do you mean with 'no success'? >Which error occured? >Did you choose the correct separator between statements >resp. between single data? (the ; above may be wrong...) > >Elke >SAP Labs Berlin > >> If you have any clue , thanks in advance. >> >> AB >> >> >> -- >> MaxDB Discussion Mailing List >> For list archives: http://lists.mysql.com/maxdb >> To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
