Chapter 14 – Things to Consider

“Never advise anyone to go to war or to marry.”

-Spanish Proverb

Teradata Mode vs. ANSI Mode

Teradata ModeANSI Mode
Transactions are implied (implicit). Explicit Transactions must use the Begin Transaction (BT) and End Transaction (ET) commands. All Transactions are explicit and require a COMMIT WORK or COMMIT statement to commit work.
All table creates default to SET Tables.All table creates default to Multiset.
Data comparison is NOT case specific. Data comparison is case specific.
Allows truncation of display data.No truncation of display data allowed.

Teradata sessions can operate in one of two modes: ANSI mode and Teradata (BTET) mode. The BTET stands for Begin Transaction End Transaction. The choice of ...

Get V14 Certification: Teradata Basics now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.