Articles & Content


New & Cool SQL: Version 8 (G10)

Topic: DB2 for z/OS

Subtopic: 2005

DATE: 2005-5-25 (08:30 AM - 09:40 AM)
SPEAKERS: William Favero (IBM DB2 for z/OS Information Management Consulting)

DB2 may be over 20 years old but it continues to crank out some very cool enhancements once again with the introduction of DB2 for z/OS Version 8. One of the exciting areas of Version 8 is its SQL. Not only are the SQL enhancements "significant", they will also increase the SQL consistency across the DB2 family. This presentation is a high level overview of the SQL being delivered in DB2 Version 8. Some, but not all, of the features that will be covered are: Multi-row INSERT & FETCH, INSERT within SELECT, SEQUENCES, Dynamic Scrollable Cursors, CURRENT PACKAGE PATH and Materialized Query Tables. The SQL in Version 8 has something new for every customer.

EXP. LEVEL: Beginner,Intermediate


Discuss the importance of DB2 Version 8

List some of the new SQL being delivered in DB2 Ve

Give examples of how to use the new SQL

List the advantages

Discuss how SQL is more consistent across platform

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.