Spice up your application with hot SQL

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

Outline:
Wide cursor
Group insert
Atomic vs non-atomic
New error processing
Merge
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.