Sunday, October 27, 2013

Teradata session mode


Teradata support both ANSI and Teradata session mode while connecting to database, the main difference between the two modes are as listed.


TERADATA Mode ANSI Mode
Comparisons are not case specific Comparisons are  case specific
ALLOWS Truncation of Display data No Truncation of Display data allowed
CREATE TABLE default to SET tables CREATE TABLE default to MULTISET tables
Each Transaction is IMPLICIT automatically Each Transaction is IMPLICIT automatically
Have to specify BT/ET explicitly Do not have to specify BT/ET explicitly

The current mode of session can be checked by "help session" query in the result set "Transaction Semantics" column represent the Session mode. or alternatively we can query dbc.SessionInfoV view as below .

SELECT transaction_mode FROM dbc.SessionInfoV WHERE SessionNo = SESSION;

we can also set the session mode as per requirement. for bteq we can simply execute below command before .logon

.set session transation BTET; ----> for teradata mode 
.set session transation ANSI;   ---> for ansi mode.

for "sql assistant" if we are connecting using odbc driver we have to set odbc connection as below.






if we are using teradata.net provider to connect , 



No comments:

Post a Comment