15.10 - JOURNAL - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

The JOURNAL keyword without AFTER or BEFORE 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 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.

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.

If BEFORE and AFTER are specified, the two must not conflict.

BEFORE
A new default for the number of before change images to be maintained for data tables subsequently created in the database by the specified user.
DUAL
Dual journal images are maintained for the table.
NO
Terminates any current journaling default.