export to
From: Stephane Legault (stephanelegault_at_yahoo.com)
Date: 02/16/05
- Next message: sojiro_at_twcny.rr.com: "Streaming Binary Data to Oracle DB BLOB"
- Previous message: Amonotod: "Re: Re: DBD::CSV much slower on osX ?"
- Next in thread: Jonathan Leffler: "Re: export to"
- Reply: Jonathan Leffler: "Re: export to"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 16 Feb 2005 08:43:33 -0500 (EST) To: dbi-users@perl.org
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?
__________________________________________________________
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
- Next message: sojiro_at_twcny.rr.com: "Streaming Binary Data to Oracle DB BLOB"
- Previous message: Amonotod: "Re: Re: DBD::CSV much slower on osX ?"
- Next in thread: Jonathan Leffler: "Re: export to"
- Reply: Jonathan Leffler: "Re: export to"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
