I'm not a DB2 expert, but the analogous facility in Informix is UNLOAD
and that is emulated in the client (command line) program. That is,
IDS (Informix Dynamic Server) does not recognize UNLOAD as a statement
but DB-Access (CLP analogue) pretends that it does.
Similar problems affect other DBMS.
On Wed, 16 Feb 2005 08:43:33 -0500 (EST), Stephane Legault
<[EMAIL PROTECTED]> wrote:
> Hi, I'am using DBI::DB2 for a lot of program and now I
> need to create a programme to archive data. So, I
> would like to export data from database to a file and
> then load that file in another db2 database.
>
> Here is what I try:
> $dbh->do(q{export to test.ixf of ixf select * from
> steph_test}) or die $dbh->errstr;
>
> But this give an error:
> DBD::DB2::db do failed: [IBM][CLI Driver][DB2/NT]
> SQL0104N An unexpected token "test" was found
> following "export to ". Expected tokens may include:
> "JOIN". SQLSTATE=42601
>
> If I'am using the export command on a command line,
> it's work well. This sould not work within perl and
> DBI?
--
Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h>
Guardian of DBD::Informix - v2003.04 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
