17.00 - JOURNAL - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

The number of BEFORE permanent journal change images to be maintained for the table. 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. 
You cannot add or modify journal options for an nonpartitioned NoPI table or for a column-partitioned table.

Journal options are not supported for tables with row sizes greater than 64KB.

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

Permanent journal change images are not maintained for the table.