This would be a nice solution, but as you know
each line in the file is a table row, so if the table
has images, then the row will be very very long, I don't
know if it will be nice to put such a line in array, and
I don't know how LOAD deals with such lines, if it deals with
it in 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 file in perl and insert the rows with regular DBI insert
statements? BTW, the reason LOAD and UNLOAD don't work from DBI is that they
are DBAccess additions, not "normal" SQL commands.
HTH,
-Darryl
-----Original Message-----
From: Mahdi A. Sbeih [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 10:08 AM
To: Jonathan Leffler
Cc: Dbi-Users; DBD Informix Maintenance Team
Subject: Using Informix LOAD and UNLOAD from DBD::Informix
Hi all,
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 only
be used from Informix DBAccess, this was a shock for me :-( .
Is there any work around, I will not be happy using DBAccess
since I don't want to use any system calls.
Thanks in advance,
regards,
Mahdi.
_____________________
Mahdi A. Sbeih
Software Engineer
IDS Software Systems
[EMAIL PROTECTED]
_____________________
____________________________________________________________________________
The information contained in this communication may be confidential, is
intended only for the use of the recipient named above, and may be legally
privileged. If the reader of this message is not the intended recipient,
you are hereby notified that any dissemination, distribution, or copying of
this communication, or any of its contents, is strictly prohibited. If you
have received this communication in error, please re-send this communication
to the sender and delete the original message and any copy of it from your
computer system.
Thank you.
For more information about Piper Marbury Rudnick & Wolfe, please visit us at
http://www.piperrudnick.com/
____________________________________________________________________________
____________________________________________________________________________
The information contained in this communication may be confidential, is
intended only for the use of the recipient named above, and may be legally
privileged. If the reader of this message is not the intended recipient,
you are hereby notified that any dissemination, distribution, or copying of
this communication, or any of its contents, is strictly prohibited. If you
have received this communication in error, please re-send this communication
to the sender and delete the original message and any copy of it from your
computer system.
Thank you.
For more information about Piper Marbury Rudnick & Wolfe, please visit us at
http://www.piperrudnick.com/
____________________________________________________________________________
