Articles & Content

Archives

SQL for the 21st Century - Overlooked Enhancements (G07)

Topic: 2011 NA

Subtopic: DB2 for z/OS



DATE: 2011-5-4 (11:00 AM - 12:00 PM)
SPEAKERS: David Simpson (Themis Inc. )

Are you still coding SQL from the 90s? This presentation focuses on SQL enhancements in the last few releases of DB2 that can greatly simplify coding and help you solve complex business problems using the power of SQL. This presentation focuses on features that have been most helpful in real applications.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Coding Table Expressions and Choosing the Right Kind

Recursive SQL - Real World Examples

Set Operations in DB2 9

Upsert Processing with MERGE

Join Syntax Options



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.