Db2 12 SQL Enhancement: Temporal Logical Transactions

    Nov 21, 2017 3: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 ...read more

     

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

    Robert Catterall

    Written by Robert Catterall