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