On Mon, 16 Jul 2001, Mahdi A. Sbeih wrote:
>I am trying to load data into tables using LOAD statement,
>and I am getting a syntax error from this:
>
>$db_handle->do("load from file insert into mytable")
>
>I spent an hour investigating this, until I found out
>that LOAD and UNLOAD statements can o
If you are loading a large file to Informix and want to avoid the
overhead of doing many inserts, you can call dbaccess from a system call
and pipe commands to it (see below). Otherwise, you need to loop and
insert each row individually.
While I love DBI, doing inserts just isn't as fast as run
such a way, then this will be a nice solution.
Regards,
Mahdi.
-Original Message-
From: Priest, Darryl - BALTO [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 4:52 PM
To: 'Mahdi A. Sbeih'
Subject: RE: Using Informix LOAD and UNLOAD from DBD::Informix
Why not open the fil
