Defines the Teradata system default transaction mode, case sensitivity, and character truncation rule for a session.
|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.|
0. The default can be overridden at the user or session level (at logon).
Changes Take Effect
After the next database restart.