What Application Developers need to know about SQL in DB2 for z/OS?

Monday, 15 June, 2015 - 14:15 - 15:15
z/OS Track
Denis Tronin
Philippe Dubost
Applications often rely on a Database to manipulate data, typically using SQL statements. DB2 for z/OS is one of those databases; one of the most robust, reliable and secure for that matter. However, Application Developers need to keep in mind that DB2 for z/OS has its SQL specificities. For instance, the SQL available in DB2 for z/OS is compliant with SQL:2003 standard. What does it exactly mean? What IBM is doing to raise the level of the DB2 SQL to later standards? How does this affect Application Developers – ever heard of APPLCOMPAT? What are the new SQL capabilities introduced in DB2 over the years? Is there something new in this area when using DB2 10 or DB2 11?
In this session, you will learn about :
  • Incompatible SQL changes in DB2 for z/OS
  • How to address incompatible SQL changes  
  • New SQL capabilities in DB2 for z/OS


SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020