Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity.
I recently worked with an insurance company on an interesting issue involving dates. They had a series of records that all had a start date but no end (or cancel) date. The end date of a record was implicitly recognized as the start date of the next highest record. This article will show you how.
There are tremendously powerful programming possibilities with SQL and many of these features are translatable across RDBMS’s with only a modest amount of effort. Utilizing these advanced SQL features can drastically reduce development time and improve performance, and so let's explore them!
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”.
Db2 introduced the MERGE statement in version 9 and made significant enhancements in Db2 12. This article shows you how.