https://www-304.ibm.com/support/docv...id=swg24029745

Some interesting SQL Enhancements:
* Pass ROWs and ARRAY's of ROWs between
JDBC and SQL Procedures and Functions
* LIKE with non constant patterns (e.g. LIKE as a "join predicate")
* Multi-Action triggers (One trigger for UPDATE/INSERT/DELETE)
* Allow UPDATE/DELETE/INSERT/MERGE in BEFORE triggers

Enjoy
Serge
--
Serge Rielau
SQL Architect DB2 for LUW, IBM Toronto Lab
Blog: tinyurl.com/SQLTips4DB2
Wiki: tinyurl.com/Oracle2DB2Wiki
Twitter: srielau

On 19 apr, 22:31, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:
Sounds like it's time for a new sequel in the "SQL on Fire!"
series... ;-)

--
Jeroen

On 4/19/2011 4:35 PM, The Boss wrote:
Prepping a talk about the "SQL PL Profiler" (see blog) for IMTC
Bangalore in two weeks.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW, IBM Toronto Lab
Blog: tinyurl.com/SQLTips4DB2
Wiki: tinyurl.com/Oracle2DB2Wiki
Twitter: srielau

On 19 apr, 22:57, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:
"The LISTAGG function aggregates a set of string values for the group
into one string by appending the string-expression values based on the
order specified in the WITHIN GROUP clause."

So no more feeling special because you know how to do it with
XMLAGG? :-(

Joking, nice release...

--
Frederik Engelen

Will there be a 9.7.4 release for Express-C anytime soon ?

On 4/20/2011 6:36 PM, Fin wrote:
Yes, my job is to make myself unnecessary ;-)

For DB2 Express C FP4 I propose asking the question in the Express C
forum. I'd be surprised if there were no refresh.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW, IBM Toronto Lab
Blog: tinyurl.com/SQLTips4DB2
Wiki: tinyurl.com/Oracle2DB2Wiki
Twitter: srielau

On 2011-04-21 00:36, Fin wrote:
9.7.4 for is now availible for download


/Lennart

Here is an example of LISTAGG(without optional WITHIN GROUP).

http://www.dbforums.com/db2/1666067-...e-session.html

I have updated from Express-C 9.7.2 to 9.7.4 and am trying this new
LISTAGG function.

During installation it created the a new SAMPLE database which worked
just fine and the sample LISTAGG command from the info center works
just great. Problem is however that trying the same command (slightly
different syntax of course) in my existing database (ex 9.7.2) fails
with :

SQL0440N No authorized routine named "LISTAGG" of type "FUNCTION"
having
compatible arguments was found. SQLSTATE=42884

Is there some upgrade command, access to grant, permission to set,
bind to perform or something similar I am missing in order to get this
new function working on my existing database ?

After apply

On 05/03/2011 11:00 AM, Fin wrote:
After applying a fixpak, you usually use the following steps to upgrade
the db.

db2updv9 -d <dbname>

db2 BIND ~/sqllib/bnd/@db2ubind.lst GRANT PUBLIC BLOCKING ALL
db2 BIND ~/sqllib/bnd/@db2cli.lst GRANT PUBLIC BLOCKING ALL
db2 BIND ~/sqllib/bnd/db2schema.bnd BLOCKING ALL GRANT PUBLIC sqlerror
continue

Try those steps and your LISTAGG should be available.

--
Helmut K. C. Tessarek
DB2 Performance and Development
IBM Toronto Lab