Hi,
Googling did not get me anywhere so hoping for some pointers here.
Using DBD::DB2, this do/prepare fails during execute:
my $sth = $dbh->prepare(qq{export to product.exp of del messages
product.mes select * from product.product where pr_upc = ?}) || die
"Couldn't prepare statement".$dbh->errstr;
Error message:
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/6000] SQL0104N An
unexpected token "product" was found following "export to ". Expected
tokens may include: "JOIN". SQLSTATE=42601
Q: Is export not allowed inside prepare ? Using "do" instead of
"prepare" generates identical error message.
Small testcase is available if required ( not included to save bandwidth
).
Notes:
1) fails from linux as well as AIX clients, DB2 V7.2 server running on
AIX 4.3.3.0 .
perl -MDBI -e 'DBI->installed_versions'
Perl : 5.008 (i386-linux-thread-multi)
OS : linux (2.4.21-1.1931.2.382.entsmp)
DBI : 1.39
.....
......
DBD::DB2 : 0.76
2) Normal DBI programs run ok in the same env.
3) The export ... statement works from shell prompt :
$db2 "export to product.exp of del messages product.mes select * from
product.product where pr_upc = '87387878278'"
Thanks in advance,
Sumitro Chowdhury.
