Articles & Content

Archives

Performance Topics for DB2 Application Coders (G05)

Topic: DB2 for z/OS

Subtopic: 2009



DATE: 2009-5-13 (09:45 AM - 10:45 AM)
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)



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.