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, Teradata Database 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, Teradata Database 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.