SessionMode Property

'Declaration
 
Public Property SessionMode As String

'Usage
 
Dim instance As TdConnectionStringBuilder
Dim value As String
 
instance.SessionMode = value
 
value = instance.SessionMode

public string SessionMode {get; set;}

public:
property String^ SessionMode {
   String^ get();
   void set (    String^ value);
}

Valid values are Default, ANSI and TERADATA.

Session Mode	Description
Default	The Advanced SQL Engine system default will be used.
ANSI	In this mode, the Advanced SQL Engine implicitly starts a transaction. However the .NET Data Provider for Teradata immediately commits each Command to simulate Auto-Commit mode required by the ADO.NET specification. The Auto-Commit simulation might add an additional overhead of one (or more for batch-update) round-trip to the Advanced SQL Engine and back. TdConnection.BeginTransaction method must be used to explicitly control the transaction. String comparisons are case specific.
TERADATA	The SQL Engine commits (Auto-Commit) each commands; thus there is less overhead as compared to the ANSI session mode. String comparisons are case insensitive.

Refer to the Advanced SQL Engine manuals for additional information about the ANSI and Teradata session modes.

Default Value: DEFAULT

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019