Defines the Teradata 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 | Vantage 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 database restart.