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.
Pity the poor developer or end user that has never had the chance to use "real" SQL. You know, the kind of SQL that does more than select a few rows with possibly a few predicates thrown in?