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;
|