Now, before starting up with our very first query, you need to know that express works in the ANSI TMODE. You need to change to TERA mode manually.
Additionally, you can have a multiple connections to the same database connection or a different one.
TERADATA MODE is not Case sensitive, where as ANSI MODE is CASE sensitive. Also, in TERADATA MODE each transaction is committed implicitly and in ANSI MODE transaction has to be committed explicitly.
