Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 19 Aug 2003 @ 18:07:16 GMT


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


Subj:   Re: Sessions holding locks after query completes?
 
From:   Dempsey, Mike

The application (Impromptu) can add the phrase 'SessionMode=ANSI' to the connect string when it issues the SQLDriverConnect() API call. This would force you into an ANSI mode session even if the ODBC DSN settings were for Teradata mode.

(A 'generic' application might do this in order to avoid having to handle different transaction semantics for different RDBMS vendors.)

Mike Dempsey
Teradata Client Tools



     
  <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: 15 Jun 2023