Articles & Content

Archives

Versus - Many SQL roads lead to Rome.. But which is best? (D15)

Topic: 2011 NA

Subtopic: DB2 for LUW



DATE: 2011-5-6 (10:30 AM - 11:30 AM)
SPEAKERS: Serge Rielau (IBM Canada )

SQL is a powerful language and in it's latest iteration DB2 9.7 has added more SQL and SQL PL features than ever before.In this presentation we'll run competing solutions against each other and see who comes out ahead and why.. When shall I use which feature.For example:temporary tables vs. using arrayscompiled SQL PL vs inlined SQL PLSQL routines vs. Java vs CSQL PL vs PL/SQL

EXP. LEVEL: Advanced

OBJECTIVES:

Learn how to choose the right SQL feature for the right job

Learn about ARRAYs

Learn about SQL PL

Learn about Complex SQL

Learn about external routines



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.