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.
DB2 includes support for On-Line Analytical Processing (OLAP) built-in functions. The first three functions introduced may be used to rank and number rows in a result table. This article will explore these three functions which are available on both DB2 for z/OS and DB2 for LUW.
DB2 10.1 and 10.5 offer new and improved SQL features, many of which can benefit existing DB2 LUW applications without disrupting their design. This article highlights some relatively approachable SQL enhancements that, once adopted, could at least simplify if not accelerate older DB2 applications.