FAQ
I am trying to export a table using dbd::db2 and failing miserably. I am
using DB2 v0.75; DBI v1.19 and perl v5.6.1 built for MSWin32-x86. And, we
are using DB2 5.2.

Here is a code snippet and the resulting error message. Any advice/sample
code etc would be greatly appreciated.

Thanks.
Mike Boyle

===============

==================Code Snippet==============

sub ExportTempTableToFile

{

my $exportName = "U:url1.ixf";

my $exportFile = "U:urltxt1.txt";

my $sql = "export to $exportName of ixf messages $exportFile select
noncedomain, parsed_url, dwparsedurlhash from globals.cydomains ";

Debug_Trace("export sql: $sql"); #My own debugging call - writes messages to
log file and command window

#Execute sql statement (#.... dies not needed with my DBI flags set)

# Tried both methods below and both failed.

$sth = $DBH->do($sql);

#$sth = $DBH->prepare($sql);

#$sth->execute();

}

#Error message returned for this version of Export attempt

DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/NT] SQL0104N An
unexpected t

oken "export to U:url1.ixf of ixf messages U:urltx" was found following
"BEGIN-O

F-STATEMENT". Expected tokens may include: "<from>". SQLSTATE=42601

DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/NT] SQL0104N An
unexpected t

oken "export to U:url1.ixf of ixf messages U:urltx" was found following
"BEGIN-O

F-STATEMENT". Expected tokens may include: "<from>". SQLSTATE=42601

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedSep 27, '01 at 2:51p
activeSep 27, '01 at 2:51p
posts1
users1
websitedbi.perl.org

1 user in discussion

Mike Boyle: 1 post

People

Translate

site design / logo © 2022 Grokbase