15.10 - DEFAULT JOURNAL TABLE - 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

A redefinition for the current journal table.

Specifying this option does not change the status of existing data tables in the modified database.

journal_table_name
Name of the default journal table. The journal_table_name parameter is required if this clause is specified without the DROP keyword.
database_name
If a database name is not specified, then the database being modified is assumed.
If the database being modified does not have a journal table, the system creates journal_table_name by default.
If a different database is specified, then it must already exist and journal_able_name must have been defined as its default journal table.
DROP DEFAULT JOURNAL TABLE
The DROP keyword removes the default status of the journal table currently defined as the default for the database being modified. If the journal table resides in the database being modified, DROP also deletes the table from the system.
An error message is returned if the DROP request would delete a journal table that is being used by active data tables.

Example: Change the default journal table

If the current journal table is not contained within the database being modified, then you could use the following request to change the default journal table from FinCopy to Jrnl1.

     MODIFY DATABASE Personnel AS
     DEFAULT JOURNAL TABLE = Jrnl1;

Example: Drop the default journal table

Two MODIFY requests are needed to change the default journal table if it is contained within the database being modified.

The journal table FinCopy is contained within the personnel database. To change the default journal table from FinCopy to Jrnl1, the present default journal table must be dropped by entering the following request.

     MODIFY DATABASE Personnel AS
     DROP DEFAULT JOURNAL TABLE;

This request removes FinCopy as the default and also drops it from the system.

If any existing tables use FinCopy as their journal table, the request returns an error message.

Example: Define a new default journal table

After default journal has been dropped, use this request to define a new default journal table.

     MODIFY DATABASE Personnel AS
     DEFAULT JOURNAL TABLE = Jrnl1;