16.20 - BEFORE JOURNAL - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1144-162K

The number of before change images to be maintained.

If the JOURNAL keyword is specified without NO or DUAL, then a single copy of the image is maintained unless FALLBACK is in effect or is also specified.

If journaling is requested for a table that uses fallback protection, DUAL images are maintained automatically.

Permanent journaling is not supported for NoPI tables, column-partitioned tables, global temporary tables, or volatile tables.

DUAL
Dual images are maintained.
NO
A journal image is not maintained.