Schedule today!

Call Peggy at
  (800) 252-0652

Contact Us

More DB2

Related Courses

Advanced DB2 Application Programming

Recommended Duration:
5 Days
DB2 Version 7. Class is suitable for those using DB2 version 5 or 6 also.
Students who complete this course will be able to: construct efficient queries in DB2 using multiple tables; discern the access strategy for a query; be able to define, load, and maintain DB2 tables; understand the use of packages; utilitize DB2 distributed data base features; code programs that use the Call Attachment Facility and dynamic SQL.
Experienced DB2 programmers who need to construct complex, efficient queries in both on-line and batch environments, understand DB2 access strategies, and access distributed data bases.
Students should have 6 months recent experience designing and coding application programs using DB2 SQL, or have completed the "DB2 Application Programming" course within the last 12 months.
Major Topics
  • Relational Access Concepts; EXPLAIN, PLAN_TABLEs and Access Strategies
  • Use of Indexes and Filter Factors; Indexable, Stage 1 & Stage 2 Predicates
  • Joins, Outer Joins, Subqueries, and Nested Table Expressions
  • Joined Access Strategies - Nested Loop, Merge Scan, and Hybrid
  • Packages; Remote Units of Work, and Distributed Units of Work; DRDA
  • Creating tables and indexes 
  • DB2 Data Types
  • Normalization
  • Modifying DB2 table definitions
  • Referential Integrity
  • Views and Synonyms
  • LOAD, REORG, and RUNSTATS Utilities
  • Call Attachment Facility
  • Dynamic SQL
  • Stored Procedures
There are five machine exercises.
This course includes the material in "Advanced SQL Query Building", and overlaps 30% with "DB2 Data Base Administration".