Re: export to
From: Jonathan Leffler (jonathan.leffler_at_gmail.com)
Date: 02/16/05
- Next message: al.danial_at_gmail.com: "insert NULL with bind_param gives uninitialized value warnings (DBD::SQLite)"
- Previous message: Tim Bunce: "Re: DBD::CSV much slower on osX ?"
- In reply to: Stephane Legault: "export to"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 16 Feb 2005 10:04:24 -0800 To: Stephane Legault <stephanelegault@yahoo.com>
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
<stephanelegault@yahoo.com> 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 <jonathan.leffler@gmail.com> #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."
- Next message: al.danial_at_gmail.com: "insert NULL with bind_param gives uninitialized value warnings (DBD::SQLite)"
- Previous message: Tim Bunce: "Re: DBD::CSV much slower on osX ?"
- In reply to: Stephane Legault: "export to"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
