specifies the type of temporal data that is contained in a table.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Requirement: | DB2 z/OS with SAS 9.4 |
| Data source: | DB2 for z/OS |
| See: | OVERLAPS= data set option, BUSINESS_DATATYPE= data set option, BUSINESS_TIMEFRAME= data set option, SYSTEM_TIMEFRAME= data set option, Temporal Data for DB2 under z/OS |
Table of Contents
specifies a temporal table that contains business time. The BUSINESS options add the following columns to the end for storing temporal data: BUS_START and BUS_END.
specifies a temporal table that contains system time. The SYSTEM option adds the following columns to the table for storing temporal data: SYS_START, SYS_END, and TRANS_START.
specifies a temporal table that contains business and system time data. The BITEMPORAL option adds the following columns to the table for storing temporal data: SYS_START, SYS_END, BUS_START, BUS_END, and TRANS_START.