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;