Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 13 Jun 2003 @ 18:43:26 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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!

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020