[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]
