Spice up your application with hot SQL

Tuesday, 16 June, 2009 - 15:45 - 17:00
Klaas Brant

Learn how to use efficiently the new programming facilities like wide cursor, array insert, merge final table.

Wide cursor
Group insert
Atomic vs non-atomic
New error processing
Final table usage

Full Abstract:
Have you started to use wide cursors under DB2 version 8? It is pretty easy and the CPU savings can be shocking! It is not very difficult to use them but there are a few things you should know about them before using them. Slightly more difficult are array inserts but also in this area you can save CPU again. DB2 version 9 bring another great feature: the MERGE statement. Complex programs can be condensed into a single, fast statement. Finally Klaas will review the so called FINAL TABLE which was introduced in version 8. Its use has been extended in version 9 and can be a great help in making your programs smaller and less complex.



SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020