RE: LOAD DATA INFILE in MaxDB

Hi Chris,

nope there's not a statement like LOAD DATA INFILE. You have to use the
loader(cli) instead. For CSV data it's quite useable but has some
limitations about BLOBs (have to be in a separate file), new-line in strings
(not allowed) etc.

<http://dev.mysql.com/doc/maxdb/en/59/025741c0c28447e10000000a1550b0/content
.htm>

Just have a look at the documentation about it. I think DATALOAD will be
your friend.

Here's an example:

Sample of an import-specification-file:
---8<---
DATALOAD TABLE <SCHEMA>.<TABLENAME>	UPDATE DUPLICATES
	ID       1
	FIELD_A  2
	FIELD_B  3
INFILE '<INPUT_FILE>'
    COMPRESSED 
    ASCII SEPARATOR ';' 
    DELIMITER ''
    TIMESTAMP 'YYYY-MM-DD HH:MM:SS'
    DATE 'YYYY-MM-DD'
    TIME 'HH:MM:SS'
---8<---

Command:
sdb@mydbserver:~> loadercli -n <DB_HOST> -d <INSTANCE> -u <USER>,<PASSWORD>
-b <COMMAND_FILE>


bye
Chris

> -----Original Message-----
> From: Christian Sell [mailto:[email protected]]
> Sent: Friday, July 13, 2007 1:14 PM
> To: [email protected]
> Subject: LOAD DATA INFILE in MaxDB
> 
> 
> Hello,
> 
>  
> 
> I'm just trying to replace the MySQL Database by a MaxDB. 
> Unfortunately I
> used quite a lot of "LOAD DATA INFILE" statements to speed up 
> INSERTS with a
> lot of entries. Is there this or an alternative statement for 
> the MaxDB too?
> 
> 
>  
> 
> Kind regard 
> 
> Chris
> 
> 

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]