This course describes the main changes in DB2 UDB for z/OS and OS/390 Version 7. It is intended for application development staff. Students should have a good knowledge of Version 6.
1 day
1 Programming Enhancements - Row Value Expressions. - Union Everywhere. - Scrollable Cursors. - Fetch First n Rows. - Self-Referencing Update and Delete. - New and Changed Functions. - Precompiler Services. 2 Design Enhancements - Enhanced Management of Constraints. - Identity Column Enhancements. - SQL Scalar Functions. - UNICODE Support. - REXX Support. - Java Support. - Index Advisor. 3 Application Performance Enhancements - IN-List Index Parallelism. - Correlated Subquery Transformation. - MIN/MAX Changes. - Join Column Mismatch. - VARCHAR Index Only Access. - Fewer Sorts for ORDER BY. - Plan Table Changes. - Star Join. - SQL Performance Analyzer. 4 Client/Server Enhancements - Global Transactions. - Security Enhancements. - Network Monitoring Enhancements. - DB2 Connect Connection and Transaction Pooling. - XML Extenders. 5 Stored Procedures Enhancements - COMMIT and ROLLBACK. - SQL Procedures. - Java Procedures and UDFs. 6 Utility Enhancements - Dynamic Utilities. - Unload Utility. - EXEC SQL and Cross Loader - Load Partition Parallelism. - On-line Load Resume. - On-line Reorg Enhancements. - Copytocopy Utility. - Recover Changes. - Statistics History. - New Utility Packaging. 7 Features and Tools - DB2 Management Client Tools. - Application Management Tools. 8 Catalog Changes 9 Version 8 Preview