DB2 Version 10.1 for Linux, UNIX, and Windows

Application development enhancements

Version 10.1 application development enhancements simplify database application development, improve application portability, and ease application deployment.

Built-in global variables expand SQL programming capabilities
Built-in global variables are global variables that are created with the database manager and are registered to the database manager in the system catalog.
Use Java generic table functions for custom analytics
With generic table functions, you can specify the output of a table function when you reference it, rather than when you create it.
Manage and query time-based data using temporal tables
Use temporal tables associated with Time Travel Query to assign time-based state information to your data. Data in tables that do not use temporal support represents the present, while data in temporal tables is valid for a period defined by the database system, customer applications, or both.
RDF application development enhancements
DB2® Resource Description Framework (RDF) contains a number of major enhancements for DB2 Version 10.1.
FP2: Distinct type support for weak typing
In DB2 Version 10.1 Fix Pack 2 and later fix packs, distinct types can use strong typing or weak typing rules.
FP2: ARRAY_AGG aggregate function enhancements
In DB2 Version 10.1 Fix Pack 2 and later fix packs, the ARRAY_AGG function is being extended to support the generation of associative arrays and arrays with a row element type.
FP2: Error locating in SQLCA expanded
In DB2 Version 10.1 Fix Pack 2 and later fix packs, when an SQL PL or PL/SQL runtime error is reported, the SQLCA that represents the error contains an object ID and a line number that identify where the error originated.