Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More DB2

Related Courses

DB2 Application Programming

Recommended Duration:
5 Days
Benefits
Students who complete this course will be able to code SQL statements to access DB2 objects, both using SPUFI under DB2I, and from within application programs (in the student's standard host environment - CICS, IMS/DB/DC, TSO, or batch). The student also learns how to establish the appropriate execution environment for programs that reference DB2 Data Bases.
Audience
COBOL, PL/I, or C programmers who need to work with DB2 Databases, both from a DB2I perspective, and from within application programs.
Prerequisites
The student should have 6 months experience designing and coding COBOL, PL/I, or C application programs in the environment (CICS, IMS/DB/DC, TSO, or batch) in which DB2 will be used; or have completed the "Structured COBOL Workshop" course within the last 12 months. Recent experience using ISPF/PDF (especially the text editor) and the ability to code JCL to run simple batch jobs is necessary to complete class assignments.
Major Topics
  • Relational Database Concepts
  • DB2 Concepts
  • DB2I, SQL, and SPUFI
  • SELECT
  • UPDATE/DELETE/INSERT
  • COMMIT/ROLLBACK
  • Joined and Nested Queries
  • Creating DB2 tables
  • DB2 Objects
  • DB2 System Catalog Tables
  • SQL in Application Programs
  • Host Variables and Structures
  • DCLGEN and SQLCA
  • BIND/REBIND/FREE
  • Cursors and Locks
  • Security and Authorization
  • EXPLAIN and Efficiency Considerations
Exercises
There are eleven machine exercises.