Articles & Content

Archives

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

Topic: DB2 for z/OS

Subtopic: 2011



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.