Articles & Content

Archives

Taking Advantage of DB2 UDB V8 Table Expressions (F06)

Topic: 2005 NA

Subtopic: DB2 for LUW



DATE: 2005-05-24 (10:00 AM - 11:10 AM)
SPEAKERS: Daniel Luksetich (Yevich, Lawson and Associates)

This presentation focuses on DB2 table expressions across all platforms. It also contains a very inspirational story and some real world examples of how table expressions were used to replace application programs and save customers considerable resources. Included are some examples of some amazingly complex SQL statements, as well as some that improved SQL application response times from days to minutes or seconds!

EXP. LEVEL: Intermediate

OBJECTIVES:

Common Table Expressions

Nested Table Expressions

Correlated Nested Table Expresions

Recursion

Performance



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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