This course covers a Technical Introduction to the following NEW SQL Features of DB2 UDB for z/OS Version Nine, including the following pureXML, New Data Types (bigger BINARY, VARBINARY, BIGINT, DECFLOAT), INSTEAD OF triggers, INTERSECT and EXCEPT, TRUNCATE Statement, MERGE Statement, Native SQL Stored Procedures, Optimistic Concurrency Control, Automatic Object Creation, Skip Locked Data, REOPT (AUTO)
-Six months of experience using DB2 UDB for z/OS Version 8 is recommended-Reading the IBM publication What's New DB2 UDB for z/OS Version Nine and / or DB2 Version Nine Announcement Letter Overview would provide a solid foundation for this course
1 Day/Lecture & Lab
This course is designed for Programmers, Analysts, Team Leads, Managers, Database Administrators who need an "appreciation and "understanding of the new "Application" features of DB2 for z/OS Version Nine.
- DB2 Version Nine System Changes Overview
- Application SQL Changes
- Hands-On Workshop Topics