SQL

In DB2® 10, SQL enhancements focus on adding new function and ensuring SQL consistency across the DB2 family of products.

Support for temporal tables and system-period data versioning
In DB2 10, you can create a temporal table, which is a table that records the period of time when a row is valid.
Enhanced support for SQL scalar functions
DB2 10 provides enhanced support for SQL scalar functions. This enhancement results in two different types of SQL scalar functions: inline SQL scalar functions and non-inline SQL scalar functions.
Support for SQL table functions
DB2 10 introduces support for SQL table functions. You can develop user-defined SQL table functions, and you can define SQL table functions to behave as parameterized views.
Enhanced support for native SQL procedures
DB2 10 provides enhanced support for native SQL procedures, which were introduced in DB2 9. This enhancement makes it easier to port applications from other members of the DB2 family or from competitive database products.
Extended support for implicit casting
DB2 10 delivers enhancements that extend support for implicit casting. These enhancements significantly simplify the porting of data to DB2 for z/OS from other database management systems, where implicit casting is supported.
Greater timestamp precision for applications
DB2 10 supports greater timestamp precision for applications that are written in host languages, such as Java, .NET, and more.
Support for TIMESTAMP WITH TIME ZONE
DB2 10 introduces a new SQL data type, TIMESTAMP WITH TIME ZONE, which further extends the TIMESTAMP data type to include time zone information.
Support for moving sums and moving averages
DB2 10 delivers online analytical processing (OLAP) specifications for moving sums and moving averages.

Parent topic: What's new in DB2 10?