Casespecific TD Environment

The Teradata DB can be forced to act CASESPECIFIC by using ANSI mode instead of Terdata mode. We can set this @

- system level using the DBS Control record
- setting in the ODBC under OPTIONS>> and set mode to ANSI for the session regardless of what the system is set to in the record

Is XX a reserved word ??

To check if a word is a reserved word, just try the below SQL

sel 1 as XX;
If it returns a value 1 then it is not a reserved word.

sel 1 as table;
will return a error 3707.