JOURNAL - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

A new default for the number of before change images to be maintained for data tables subsequently created in the database.

This option can appear twice in the same request: once to specify a BEFORE or AFTER image, and again to specify the alternate type. If only one type is specified, then the current default is modified only for that type.

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

NO
Terminates any current journaling default.
DUAL
If the JOURNAL keyword is specified without NO or DUAL, single copy journaling is implied. If journaling is specified, a DUAL journal is maintained for data tables with FALLBACK protection.
Existing images are not affected until the corresponding table is updated.
BEFORE
The JOURNAL keyword without BEFORE or AFTER indicates that both types of images are to be maintained. In this case, the current default for either or both types is modified accordingly. For example, if only AFTER JOURNAL is specified, the current default for before change images remains in effect.
If BEFORE and AFTER are specified, the two must not conflict.