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!
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.
This article is dedicated to SQL/XML functions. The article is built around simple examples to illustrate how those functions can be used in certain scenarios.
This article starts a serial devoted to Db2 for z/OS System Profiles. Profiles are still not widely used and known while they represent a strong capability allowing to automatically tune the system. This introductory article discusses how you can define and activate a system profile.
Did you know that you can issue SQL statement to Db2 for z/OS using File Transfer Protocol (FTP)? If not, make sure you read this new brand article!