Home About Courses Schedule Services Webinars Contact Search

Db2 12 for z/OS Transition for SQL Developers


Duration: 1 Day

Method: Instructor led, lecture only.

Price: $600.00

Course Code: DB2112


SQL Developers that regularly use Db2 for z/OS as a development platform.


Learn all about the new SQL features of Db2 for z/OS in this fast paced one day course! We'll focus only on the features that relate directly to application development.


Upon successful completion of this course, the student will be able to:

  • Effectively use the new features of Db2 12 for z/OS
  • Understand how new features will be delivered going forward


A working knowledge of Db2 for z/OS.


  • I. Db2 12 Overview
    • Why Db2 12?
    • Phases of the Migration
  • II. Continuous Delivery of New Functions
    • Overview of currently available function levels
    • Controlling new features and incompatibilities at the application level
    • APPLCOMPAT bind parameter
  • III. Temporal Table Enhancements
    • Business Time Control
    • System Time Enhancements
      • Track all SQL modifications
      • Track who modified data
      • Logical Transactions
  • IV. SQL Enhancements
    • MERGE Statement Overhaul
    • Piece-wise DELETE
    • SQL Pagination (scroll forward/back queries)
  • V. SQL Performance
    • Sort Improvements
    • Execution time adaptive indexes
    • Expression sharing
    • Access path stability features