Articles & Content
Topic: 2005 NA
Subtopic: DB2 for z/OS
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.