DB2 V9 SQL Enhancements

Date: 
Friday, 11 April, 2008 - 11:15 - 12:15
Speaker: 
Florence Dubois

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

 

sqladria

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

facebook
linkid
twitter

 

Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020