Home About Courses Schedule Services Webinars Contact Search

DB2 for z/OS Advanced Embedded Programming

SEE SCHEDULE

Duration: 2 days

Method: Instructor Led, Hands-on Workshops

Price: $1125.00

Course Code: DB1042



Audience

Developers who code SQL queries embedded in host languages such as COBOL.

Description

Have you been coding SQL in embedded programs such as COBOL for a while and looking to fine tune your skills? If so, this course is for you. Learn some advanced techniques for coding cursors including some of the new features in the latest releases of DB2. Also learn how DB2 locking affects the way programs should be coded. The course concludes with a primer on SQL optimization and the toolset provided by IBM for optimizing the queries in a program.

Prerequisites

DB1010 or equivalent experience

Topics

  1. DB2 and SQL Components
    • Databases and Physical Objects
    • Tables and Indexes
    • Object Dependencies
  2. Using Scrollable Cursors
    • Sensitive Static
    • Insensitive Static
    • Sensitive Dynamic
    • Positioned Updating and Deleting
    • Choosing the Right Cursor Type
  3. Multi-Row Operations
    • Multi-Row Fetch
    • Multi-Row Insert
    • MERGE Statement
    • Multi-Row Merge
    • SELECT from Insert/Update/Delete/Merge
    • GET DIAGNOSTICS Error Handling
  4. Locking Strategies & Concurrency
    • DB2 Concurrency Control
    • Aspects of Transaction Locks
    • ISOLATION Bind Parameter
    • CURRENTDATA Bind Parameter
    • Lock Avoidance
    • Optimistic Locking Techniques
    • SKIP LOCKED DATA clause
  5. SQL Performance
    • DB2 Optimizer Overview
    • Tuning Approaches
    • Explain
    • IBM Data Studio
    • Reading Access Paths
    • Access Path Choices