SQL statement changes in DB2 9

This release of DB2® for z/OS® provides new and changed SQL statements.

New SQL statements in DB2 9
This release of DB2 for z/OS includes new SQL statements.
Changed SQL statements in DB2 9
In this release of DB2 for z/OS, many existing SQL statements have new and changed clauses.
New functions in DB2 9
This release of DB2 for z/OS includes new built-in functions that improve the power of the SQL language.
Reserved words
Certain words cannot be used as ordinary identifiers in some contexts because those words might be interpreted as SQL keywords. For example, ALL cannot be a column name in a SELECT statement. Each word, however, can be used as a delimited identifier in contexts where it otherwise cannot be used as an ordinary identifier. For example, if the quotation mark (") is the escape character that begins and ends delimited identifiers, "ALL" can appear as a column name in a SELECT statement.
Other SQL language changes in DB2 9
In addition to the many new SQL statements and functions, this release of DB2 for z/OS includes other enhancements to existing SQL statements.

Parent topic: Planning when migrating from DB2 Version 8