• SQL and Development Enhancements
  • Column Naming and Renaming
  • Nested Table Expressions
  • Join Enhancements
    • Inner Join
    • Left Outer Join
    • Right Outer Join
    • Full Outer Join
    • Handling null values in outer joins
    • Outer join with more than 2 tables
    • Outer join notes and restrictions
  • Uncommitted Read (UR) (also known as "dirty read" or "read through locks")
  • Row level locking
  • Table Check Constraints
  • User-defined default values
  • Stored Procedures
    • Why use stored procedures?
    • Creating a stored procedure
    • Stored Procedure Execution
    • Stored Procedure Access to VSAM, CICS, and IMS
    • ODBC Access to Stored Procedures
  • DCLGEN Enhancements
• Performance, System, and Administrative Enhancements
  • Type 2 Indexes
  • Query CPU Parallelism
  • True Partition Independence
  • DFSMS Concurrent Copy
  • DYNAMICRULES Bind Option
  • Sysplex Data Sharing
  • Miscellaneous Improvements
• IBM Sample Tables

---

©Copyright 1996 Chuck Anesi all rights reserved

©Copyright 1995-2006 Chuck Anesi all rights reserved