SYSCAT.PERIODS catalog view

Each row represents the definition of a period for use with a temporal table.

Table 1. SYSCAT.PERIODS Catalog View
Column Name Data Type Nullable Description
PERIODNAME VARCHAR (128)   Name of the period.
TABSCHEMA VARCHAR (128)   Schema name of the table.
TABNAME VARCHAR (128)   Unqualified name of the table.
BEGINCOLNAME VARCHAR (128)   Period begin column name.
ENDCOLNAME VARCHAR (128)   Period end column name.
PERIODTYPE CHAR (1)   Type of period.
  • A = Application period
  • S = System period
HISTORYTABSCHEMA VARCHAR (128)   Schema name of the history table.
HISTORYTABNAME VARCHAR (128)   Unqualified name of the history table.