DB2 Server for VSE Application Programming

LENGTH OF COURSE:
5 Days

DESCRIPTION: This course is designed to guide students in building application programs using DB2 for VSE resources in an efficient manner.

PREREQUISITES: Knowledge of a text editor, a programming language and an understanding of basic programming concepts. COBOL programming examples are included throughout the course.

INSTRUCTION TECHNIQUES: A combination of Lecture, Exercises, and Labs (when/where available).

AUDIENCE

Programmers, Analyst, and Managers that need to understand how to design, develop, and code a DB2 VSE application programs using a common programming language.
KEY HIGHLIGHTS:

  • DB2 VSE Overview
    • DB2 VSE and Data Objects
    • Tables, DBSPACE
    • Simple, Partitioned, and Segmented DBSPACES
    • Storage Pools, Databases, Indexes
    • Systems Objects and DB2 Catalog
  • DB2 Data Types & NULLS
  • SQL DML and DDL
    • SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING, UNION
    • CREATE, ALTER, DROP
  • Advanced SQL
    • Nulls
    • Boolean Operations
    • Valued Logic
    • Built-In Functions
    • Join
  • DB2 Interactive SQL
  • Preparing the DB2 Application Program
    • Precompile of Program
    • BINDing Packages
    • UPDATE STATISTICS
    • Embedded SQL Concepts
    • SQL Coding & Embedded SQL
    • Singleton vs. Cursor Processing

  • Program Structure
    • Host Variables and Structures
    • Null Processing
    • SQLCA
    • Program Aids
    • Using DSNTIAR
    • WHENEVER
    • Recovery
    • Locks, Lock Table, Timeout
    • Deadlock
  • Security
    • GRANT / REVOKE
  • Dynamic SQL
    • Static vs. Dynamic SQL
    • SQL Statement Processing
    • Dynamic SQL and SQLDA
    • Execute Immediate
    • Prepare and Execute
    • Fixed-List Select
    • Varying-List Select
    • Resource Limit Facility
  • Performance Considerations
    • Execution Components
    • DBAS Subcomponents
    • SQL Processing and Tuning
    • Non-Indexable
    • Indexable Predicates
    • Stage 1 and 2 Predicates
    • SQL Coding Tips
    • Indexes and Filter Factors
    • Sequential Prefetch
    • Joins


  • EXPLAIN Facility
    • Referential Integrity
    • Overview and Terminology
    • RI Rules
    • DDL
    • PRIMARY AND FOREIGN KEYS
    • DML Restrictions
    • DB2 - Enforced vs. User-Enforced
  • Batch Considerations
  • Locking and Concurrency
  • IBM Query Management Facility
  • DB2 VSE Utilities


FROM OUR STUDENT EVALUATIONS...
"If Robert is representative of Jeff Markiewicz & Associates we at EDS should make sure to use their excellent services often in the future."

Aaron Alanen
EDS

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.