Recent Articles
Posted By: Jan Marek
Thu Mar 8th, 2018
The last post of the XML series. This time we discuss the Db2 12 that introduced a couple of interesting enhancements to the SQL/XML functions.
Posted By: Chris Crone
Thu Jan 25th, 2018
En la Parte 1 de este artículo, presentamos la primera de dos mejoras de SQL altamente solicitadas por muchos clientes en Db2 12 – “DELETE por parte”. En esta Parte 2, veremos las mejoras en “MERGE”.
Posted By: Kurt Struyf
Sun Jan 7th, 2018
In the early days of DB2 for z/OS, pretty much every change to a table would result in an unload-drop-recreate-load of the table. This article will talk about how the ALTER table in DB2 12 for z/OS has evolved from DB2 11 for z/OS and what you need to know from a practical point of view.
In DB2 11
Posted By: Chris Crone
Sat Sep 9th, 2017
Db2 introduced the MERGE statement in version 9 and made significant enhancements in Db2 12. This article shows you how.
Posted By: Chris Crone
Mon Jan 30th, 2017
In Part 2, we will examine how to exploit Application Compatibility (APPLCOMPAT) which was introduced in DB2 11, and Function Levels which is introduced in DB2 12 to safely manage change. The levels of APPLCOMAT you can specify is limited by the Function Level of your system.
