BTEQ: SET SESSION TRANSACTION in Teradata

 Following way, you can see current session transaction mode in your session

SELECT transaction_mode FROM dbc.sessioninfo

WHERE sessionno = SESSION;

-- Result: T

 Or

HELP SESSION;


There is two type of Session Transaction mode in Teradata

1.     BTET - Teradata mode

2.     ANSI - ANSI mode

 

Following way, you can set or change the session transaction mode in Teradata

Set session transaction mode to Teradata mode

.SET SESSION TRANSACTION BTET;

Set session transaction mode to ANSI mode

.SET SESSION TRANSACTION ANSI;

 

Comments