O'Reilly logo

Teradata Physical Database Design by Tom Coffing, Leah Nolander

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8 – Things to Consider

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

-Spanish Proverb

Teradata Mode vs. ANSI Mode

Teradata Mode ANSI 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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required