What have you missed during month of April ?
April wat advanced SQL month for the content committee so we had articles by Dan Luksetich, Brian Laube and David Simpson.
For our premier members great new videos were released.
You can find a ton of articles about recursive SQL dating back as early as 2004, but for this article I was asked to provide actual real-world situations where recursive SQL was put to use. In all of the situations it was a great success!
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.
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.