Federation support of temporal tables gives you the ability
to create a nickname over a remote temporal table.
You can define a table with temporal attributes to create
the following types of temporal tables:
- System-period temporal tables that maintain historical versions
of its rows
- Application-period temporal tables that store data based on time
criteria
- Bitemporal tables that are a combination of system-period temporal
tables and application-period temporal tables
When you create a nickname over a temporal table, you
can perform insert, update, and delete operations against the nickname.
Example
- Define a table named policy_info_bus:
CREATE TABLE policy_info_bus ( policy_id CHAR(4) NOT NULL,
bus_start DATE NOT NULL, bus_end DATE NOT NULL,
PERIOD BUSINESS_TIME(bus_start, bus_end) );
- Issue a query against a temporal table nickname:
SELECT * from policy_info_bus_nickname;
However, temporal operations over nicknames are not supported.
You cannot perform temporal DDL operations, alter operations, or query
operations against nickname. For example, you cannot query the system
time as of a specific date as shown in the following example:
SELECT * FROM policy_info_bus_nickname FOR BUSINESS_TIME AS OF '2012-12-02';