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

Reply via email to