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.
Other SQL dialects support similar non-ANSI standard statements with names such as the following.
- SET CURRENT ISOLATION
- SET ISOLATION
- SET TRANSACTION
- SET SESSION CHARACTERISTICS
Although SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL is technically a DCL statement, Teradata Database treats it as a DDL statement for transaction semantics.