DB2 V9 SQL Enhancements

Objectives:
This presentation provides an overview of the major SQL-related enhancements introduced by DB2 9 for z/OS regarding data types and DML. These enhancements will help improve the productivity of SQL application programmers and allow better portability of applications.

Outline:
INTERSECT, EXCEPT
INSTEAD OF triggers
MERGE
SELECT FROM MERGE / UPDATE / DELETE
TRUNCATE
ORDER BY/FETCH FIRST in subselect
New data types: BIGINT, BINARY, VARBINARY, DECFLOAT