Purpose
Defines the Teradata Database system default transaction mode, case sensitivity, and character truncation rule for a session.
Field Group
General
Valid Settings
| The setting… | Defaults SQL sessions to… |
|---|---|
| 0 | Teradata Database transaction semantics, case insensitive data, and no error reporting on truncation of character data. |
| 1 | ANSI transaction semantics, case sensitive data, and error reporting on truncation of character data. |
Default
0. The default can be overridden at the user or session level (at logon).
Changes Take Effect
After the next Teradata Database restart.