What's new for V5R4
The major new features covered in this book include:
- ISO timestamp format
- Blanks in hex literals
- SESSION_USER, SYSTEM_USER, CURRENT DEBUG MODE, and CURRENT DEGREE special
registers
- Fullselect in a subquery and scalar fullselect
- Recursive common table expressions and recursive views
- ROW_NUMBER and RANK OLAP specifications
- row-value-expressions in predicates
- ENCRYPT_TDES, GENERATE_UNIQUE, and RAISE_ERROR scalar functions
- ADD_MONTHS, LAST_DAY, NEXT_DAY, and VARCHAR_FORMAT scalar functions
- STDDEV_SAMP and VARIANCE_SAMP aggregation functions
- ORDER OF in ORDER BY
- USE AND KEEP EXCLUSIVE LOCKS
- ALLOCATE DESCRIPTOR, DEALLOCATE DESCRIPTOR, GET DESCRIPTOR, and SET DESCRIPTOR
- ALTER PROCEDURE
- ALTER TABLE ACTIVATE NOT LOGGED
- Materialized Query Tables (optimizer awareness)
- VOLATILE tables
- RCDFMT clause on tables and views
- PAGESIZE index option
- INSTEAD OF triggers
- DESCRIBE INPUT
- LABEL ON INDEX
- SET CURRENT DEBUG MODE
- SET CURRENT DEGREE
- SET SESSION AUTHORIZATION
- 2MB SQL statements
- 128 byte column names
- 32K key and ORDER BY length
- 1024 parameters for C, C++, and SQL procedures
- 1000 tables in an SQL statement
- Greater than 31 subqueries in an SQL statement
- XA support over DRDA(R)
- ILE RPG Precompiler support for free-form RPG
How to see what's new or changed
To help you see where technical changes have been made, this information
uses:
- The
image to mark where new or changed information
begins.
- The
image to mark where new or changed information ends.
To find other information about what's new or changed this release,
see the Memo to users.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.