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!
I searched for the manual which would explain how to write proper SQL. I never found it and the more I talked to people on which strategy I should follow, the less useful information I seemed to get. The same was true whenever I asked for general rules to decide which index was needed.
Customers have a wealth of data in their databases and publishing it to different devices is often fraught with many challenges. OData tries to remove much of the complexity of communicating with the database
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.
With Db2 for z/OS customers expanding their business presence into the mobile client world, solution developers are seeking more efficient ways to leverage existing data and business logic to support this. The REST native API is designed to assist with this.