Articles & Content

Archives

Performance Topics for DB2 Application Coders (F05)

Topic: 2009 EU

Subtopic: Cross Platform DB2 for z/OS & LUW



DATE: 2009-10-6 (11:00 - 12:00)
SPEAKERS: Sheryl Larsen (Sheryl M. Larsen, Inc.)

Efficient coding techniques that turn DB2 data into precious information will be demonstrated throughout the day. Powerful techniques from DB2 V1 through DB2 X will be provided; topics like data warehouse queries, refining summaries, table pivoting, and many more.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Demonstrate what is the best SQL for Data Warehouse Queries

Demonstrate the most efficient SQL for Refining Summaries

Demonstrate the most efficient SQL for Table Pivoting

Demonstrate the most efficient SQL for Finding the Needle in the Haystack

Demonstrate the most efficient SQL forCalculating Gaps in Column Values (any data type)



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.