Articles & Content


DB2 for z/OS V8 Experiences in SQL and Programs (E13)

Topic: 2006 EU

Subtopic: DB2 for z/OS

DATE: 2006-10-4 (17:30 - 18:30)
SPEAKERS: Sheryl Larsen (Sheryl M. Larsen, Inc.)

Can you justify a programming swat team to tear through your legacy applications? This presentation will demonstrate which V8 SQL and programming features had the most impact in Full Function Mode. Specifically, what is the gain from converting to multi-row cursors, Multi-row INSERT, Dynamic Scrollable Cursors, GROUP BY Expression, Materialized Query Tables, Common Table Expressions, Recursive SQL, and more.

EXP. LEVEL: Intermediate


V8 SQL Hot Features

Conversion impact

Performance Gain


Migration Strategy

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.