Changes the default transaction isolation level read-only semantics for the current session.
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL is ANSI SQL:2011-compliant with extensions.
ANSI SQL does not support the abbreviations RU and SR. They are Teradata extensions.
- SET CURRENT ISOLATION
- SET ISOLATION
- SET TRANSACTION
- SET SESSION CHARACTERISTICS
Although SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL is technically a DCL statement, Vantage treats it as a DDL statement for transaction semantics.