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

Seminar:

European SQLAdria Seminar – Dubrovnik 2015

Date:

Monday, 15 June, 2015 - 14:15 - 15:15

Program:

z/OS Track

Speaker:

Denis Tronin

Speaker:

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

14 June 2015

Introduction -

CA Technologies Mainframe Solutions - Steve Thomas

Highlights of r18 new features and high-level roadmap for r19 - Philippe Dubost

Break -

What’s new in CA SYSVIEW for DB2? - Denis Tronin

What is CA MSM/E? - Maddalena Tosoni

Q & A -

Networking Event -

15 June 2015

Introduction -

The DB2 11 catalog – something new, something old, something changed - Steen Rasmussen