DBD：：Informix的upload问题

fakepersona

代码如下，错误是
DBD::Informix::db prepare failed: SQL: -201: A syntax error has occurred. at ./code4 line 8.
Can't call method "execute" on an undefined value at ./code4 line 9.
希望高手帮忙，谢了！

1. #!/bin/perl
   
2. push @INC , "/usr/local/lib/perl5/site_perl/5.8.3/aix-thread-multi" ;
   
3. require DBI;
   
4. #$DSN = "DBI:"
   
5. require DBD::Informix ;
   
6. $dbh = DBI->connect("DBI:Informix:faint\@cxcs") or die "Database unavaliable;";
   
7. my $tmp = "unload to txt select * from orders;" ;
   
8. my $uload = $dbh->prepare($tmp);
   
9. $uload->execute();
   
10. $dbh->disconnect();
    

复制代码

fakepersona

又：unload to txt select * from orders这一句在dbaccess下是没问题的，为什么perl执行会有问题？

yybmsrs

my $tmp = "unload to txt select * from orders;" ;

把sql中的;去掉试试

fakepersona

回复 3# yybmsrs


    一样的，还是-201错误

syncpk99

unload语句是dbaccess提供的功能，不是标准的SQL语句