Archives of the TeradataForum
Message Posted: Tue, 19 Aug 2003 @ 18:07:16 GMT
| 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
| 
