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