Temporal Support of Db2 for z/OS – Part III Temporal RI By Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Background and Motivation What is referential integrity (RI)? Referential integrity (RI) is the state in which all values of all foreign keys are...
Temporal Support of Db2 for z/OS – Part I Temporal Auditing Enhancements in Db2 12 Continuous Delivery Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Abstract This article series discuss the major Db2 temporal enhancements delivered in Db2 12 for z/OS...
Attached is a copy of my slide-deck for the DB2’s Got Talent - 2016 contest Hope the sample code content is useful
Some helpful DB2 LUW sql and db2cos script discussion.pdf
XMLModify function: sub-document update on an XML document In DB2 9 for z/OS, an update on an XML document is a delete of whole document following by a new insert. Since DB2 10 for z/OS, we are able to do sub-document update using XMLModify function. As you may know, DB2 for z/OS stores...
The new SQL Reference for Cross-Platform Development has arrived In May of this year, IBM published the newest version of The SQL Reference for Cross-Platform Development. This document, known also as the Cross-Platform SQL Reference, or CP SQL Reference, is intended for developers who...