JOURNAL - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

The type of permanent journal image to be maintained for the table. The default is set by the CREATE DATABASE, CREATE USER, or MODIFY USER statement for the database in which the table resides. When you specify the JOURNAL keyword without also specifying AFTER or BEFORE, Vantage maintains both types of images. This option can appear twice in the same request: once to specify a BEFORE or AFTER image and again to specify the alternate type. You cannot add or modify journal options for a nonpartitioned NoPI table or for a column-partitioned table.

BEFORE JOURNAL
If you specify only one type of journaling, Vantage overrides only the default for that type. For example, if you specify AFTER, then BEFORE image journaling remains at its default setting. If you specify BEFORE and AFTER journaling, the two specifications must not conflict with one another.