Sheryl M. Larsen, Inc., SMLI, is a firm specializing in Advanced DB2 Consulting and Education - www.smlsql.com. Sheryl M. Larsen is the founder/president and is an internationally recognized researcher, consultant and lecturer, specializing in DB2. She is known for her extensive expertise in SQL, has over 20 years experience in DB2, published many articles, and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. She was voted into the IDUG “Speaker Hall of Fame” in 2001 and was the Executive Editor of the IDUG Solutions Journal magazine 1997-2000. Currently, she is President of the Midwest Database Users Group - www.mwdug.org, and a member of IBM’s DB2 Gold Consultants program.

Abstract:
This will be an intense update on the newest and most powerful SQL enhancements. DB2 V8 and V9 for z/OS top SQL performance enhancements will be discussed in terms of positive application impact including stage 1 unlike data types, multi-row INSERT, multi-row FETCH, Materialized Query Tables (MQTs), common table expressions, recursive SQL, INSERT with SELECT/UPDATE/DELETE/MERGE, ORDER BY/FETCH FIRST in subselect, in memory data caching, and many, many more.