Hi
I had a problem using Perl scripts to import text
file into DB2 database. Could someone helps me to get
over this problem. One of my projects I am working on
needs to import text file in to database.
I had DB2 Enterprise Edition Version 8 and Active
Perl Version 5.8 installed in my computer. When I
used Perl scripts to execute the DB2's sql statement
such as select, create table, update .... I got no
problem at all, but I got a problem to import text
file into DB2 database. The syntax looks like this.
#! c:\perl\bin\perl
use DBI;
$dbi_Driver = "ODBC";
$dbi_DBName = "MyDatabase";
$user = "username";
$pwd = "password";
$dbh = DBI->connect
'dbi:'.$dbi_Driver.':'.$dbi_DBName,$user,
$pwd,{RaiseError => 1, PrintError => 1}) || die
"unable to make a database connection open DB";
$sql = "import from c:/person.txt of del insert into
person";
$sth = $dbh->prepare($sql);
$sth->execute();
$sth->finish();
When I executed the sql statement "import from
c:/person.txt of del insert into person" at the DB2
Command Line Processor, I did not get any problem at
all. But it raised an error when I used Perl Script
to execute this sql statement. The error looks like
this
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/NT]
SQL0104N An unexpected token "import from
c:/person.txt of del" was found following
"BEGIN-OF-STATEMENT". Expected tokens may include:
"". SQLSTATE=42601
Please help, any input would be appriciated.
Thanks a lot
Dung Nguyen
=====
[EMAIL PROTECTED]
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
