DB2 9.7. Fixpack 5 released -
10-27-2011
, 04:01 PM
http://www.ibm.com/support/docview.wss?uid=swg24031181
On the SQL front here are the highlights:
* Nested complex types support
That is multi dimensional arrays, rows in rows, arrays in rows etc...
JDBC is also supporting this.
* NVL2, HEXTORAW functions
* Allow scalar functions returning arrays in the FROM clause
That means you have defacto another way to write complex
table function
* anonymous blocks with rollback.
Anonymous blocks are now compiled in an autonomous transactions.
That means you can rollback within the block beyond the beginning of
the block.
Cheers
Serge
--
Serge Rielau
SQL Architect DB2 for LUW, IBM Toronto Lab
Blog: tinyurl.com/SQLTips4DB2
Wiki: tinyurl.com/Oracle2DB2Wiki
Twitter: srielau |