Have you heard about the Lateral join? In short - lateral join or lateral correlation is simply a reference in a nested table expression to a column of a table identified at the same level in the FROM clause. Learn the basics in this article.
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!
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.