|
|
Archives of the TeradataForum
Message Posted: Fri, 13 Jun 2003 @ 18:43:26 GMT
Subj: | | Re: Perl and DBD::Teradata 1.13 |
|
From: | | Geoffrey Rommel |
| While writing a Perl script which accesses locally a Teradata database via DBI and DBD::Teradata 1.13, I encountered some unexpected
errors related to a premature error while fetching data from a SELECT statement. The same SELECT statement works quite easily in
WinDDI. | |
| In the middle of a fetching loop, it stops complaining
ERROR 3119: Continue request submitted but no response to return. | |
I believe the problem is that you have two request handles open ($stmt and $update). According to the documentation for
DBD::Teradata, this is invalid; you must open two connections (two sessions) and have only one request open at a time in each one. (I quote:
"... you can't execute new requests on a database handle that has a currently open and active request on it. Either finish() the current
request first, or use an additional connection to issue the new request.") Good luck!
| |