I am using DBI to connect to a DB2 LUW database. It seems I cannot use DBI to issue the IMPORT command.
my $dbh = DBI->connect( "dbi:MSDB2:$DB_NAME", '', '', { 'RaiseError' => 1 } ); dbh->do("import from $filename of del insert into $tabname"); DBD::MSDB2::db do failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "import" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<values>". SQLSTATE=42601 Melinda Song Morgan Stanley | Technology & Data 210 Carnegie Center | Princeton, NJ 08540 Phone: +1 609 936-4674 qing.s...@morganstanley.com<mailto:qing.s...@morganstanley.com> -------------------------------------------------------------------------- NOTICE: If received in error, please destroy, and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. We may monitor and store emails to the extent permitted by applicable law.