IDUG blog roundup: Db2 12 for z/OS SQL enhancements
Paul_McWilliams 110000JT36 Visits (3684)
In a series of recent articles in the IDUG content blog, Chris Crone and Meg Bernal describe three new SQL capabilities that Db2 12 for z/OS introduces: piece-wise delete, enhanced MERGE capability, and new SQL pagination capabilities.
Chris and Meg discuss the piece-wise DELETE syntax in DB2 12, which allows the FETCH FIRST n ROWS ONLY clause to be specified on a searched DELETE statement. The new DELETE syntax enables clients to delete large numbers of rows from a table without severely impacting the system, by mitigating the effect of locking large number of rows, or having lock escalation occur. Read the article.
Chris and Meg discuss the new capabilities introduced for MERGE statements in Db2 12, which enables application developers to literally fold large amounts of application logic into one SQL statement. Read the article.
Meg discusses the new SQL syntax in Db2 12 for SQL pagination, the ability to “page” through a result set. The new syntax supports both data-dependent pagination, to return a subset of data based on predicates, and numeric pagination, which starts from a particular starting row of the result set. Read the article.