Yet more new information about DBG2 UDB for iSeries enhancements at V5R2.

This is on top of the earlier stuff. V5R2 is looking like a huge release for DB2 - possibly the biggest since the initial System/38 release all those years ago.

Scalar subselects are the kind of thing that don't look too exciting. Until you need them, that is, at which point you really need them.

Savepoints also look really handy, as do external UDTFs. UDTFs, User Defined Data Tables, allow you to treat the output of a program as an SQL table.

Temporary tables are somewhat useful - nothing you can't do by creating tables in QTEMP, but these will work cross-platform.

Also in The Four Hundred this week - a summary of the state of play with WebSphere Development Studio Client (WDSc) and Eclipse for the iSeries, (no news here, but a nice summary anyway,) and an article explaining why companies should hire mediocre rather than talented people, which explains why I have a job.