Toad World Blog

Db2 12 SQL Enhancement: Temporal Logical Transactions

Nov 21, 2017 2:07:00 PM by Robert Catterall

Temporal data support, introduced with Db2 10 for z/OS, is one of the more interesting SQL-related Db2 enhancements delivered in recent releases of the DBMS. Temporal data support comes in two flavors (which can both be utilized for a single table): business-time temporal and system-time temporal. With business-time temporal support enabled for a table, an organization can put future changes into the table (e.g., price changes for products or services that will not go into effect until some future more


Tags: Toad for IBM DB2 IBM DB2 DB2 z/OS SQL

Robert Catterall

Written by Robert Catterall