IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

SQL on Fire (New Edition!)

Session Number: 2300
Track: DB2 9.7 for LUW (C)
Session Type: Podium Presentation
Primary Presenter: Serge Rielau [IBM Canada]
Time: Nov 15, 2011 (11:00 AM - 12:00 PM)
Room: Aquarius

Speaker Bio: Serge Rielau got interred into IBM's Toronto penal colony from the University of Kaiserslautern/Germany (aka K-Town) 13 years ago. Having previously served a year's time at the Almaden Research Lab where he got into DB2 his life took a turn for the worse (see "OO what have they done to DB2?!"). Over the years Serge has been guilty of many crimes including SQL Functions, generated columns and what's come to be known as the "new SQL": select from insert, update and delete! No bad deed goes unpunished though. He is now serving time as DB2 for LUW's SQL Architect and is accused of being an STSM. Not having learned a thing and obviously becoming d
Audience experience level: Intermediate
Presentation Category: Managing Performance
Presentation Platform: Select a Value
Audiences this presentation will apply to: Application Developers, Database Administrators
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Triggers, Stored Procedures, UDFs
Objective 1: Introduce ways to write maintainable SQL PL code
Objective 2: Learn when and how to use arrays vs CGTT, DGTT
Objective 3: Inline vs. compiled SQL PL
Objective 4: Connect triggers
Objective 5: .. and much more...

Abstract:  In this presentation we will continue to introduce some nifty ways to write SQL you may or may not have thought about before. The topics will include old but largely unknown features as well as new and not yet known ones.
For example we will illuminate how to write fast SQL PL, write code that is resilient to schema evolution and much more.

For questions or concerns about your event registration, please contact