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