----- Original Message ----
> From: "Song, Melinda" <qing.s...@morganstanley.com>
> 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
Hi Melinda,
I was surprised to see that there was an MSDB2 driver, but Google suggests that
this is a Morgan Stanley subclass of the DB2 driver. That makes this harder to
debug. You may have to contact whoever wrote DBD::MSDB2, but I can't say I
know DBI internals well enough to know if that's a reasonable route.
Googling for your exact error returns limited results, but I see that others
get this result without DBI:
http://www.dbforums.com/db2/1618417-truncate-table-db2.html
That suggests that an older version of DB2 might be involved, but it's a
different route taken to reach that error, so again, I've no idea if that's
relevant.
Sorry I can't be of more help.
Cheers,
Ovid
--
Buy the book - http://www.oreilly.com/catalog/perlhks/
Tech blog - http://blogs.perl.org/users/ovid/
Twitter - http://twitter.com/OvidPerl
Official Perl 6 Wiki - http://www.perlfoundation.org/perl6
