Referential integrity (RI) is the state in which all values of all foreign keys are valid. Both traditional RI and temporal RI are relationships between pairs of tables, in which the business rules are represented. In Db2 V8, informational RI (with NOT ENFORCED keyword) was added to benefit certain
This article series discuss the major Db2 temporal enhancements delivered in Db2 12 for z/OS and Db2 for z/OS Continuous Delivery (CD), e.g., temporal logical transaction, temporal RI, and replication and temporal query enhancements on temporal auditing.
With the temporal logical transaction support of Db2 12, Db2 allows an application to specify and manage the scope of temporal work easily and concisely. Both physical and temporal logical transactions can happen sequentially and/or concurrently without violating the integrity of the data. In additi
Db2 12 SQL Pagination: The ability to "page" through a result set and see the next "page" of results. Db2 12 introduced support for data-dependent and numeric-based pagination.
I searched for the manual which would explain how to write proper SQL. I never found it and the more I talked to people on which strategy I should follow, the less useful information I seemed to get. The same was true whenever I asked for general rules to decide which index was needed.