- 6 hours
The Create and Maintain DB2 Programs course describes how SQL is invoked from an application program and the interaction that can occur between the application program and DB2. This course also discusses how a DB2 COBOL Program is created.
Programmers and DBAs requiring training in writing application programs to reference and update DB2 data, particularly in the mainframe environment.
Completion of the courses 'Manage Data Definitions with DB2', 'DB2 SQL Fundamentals', and 'Advanced DB2 SQL' and basic knowledge of DB2, relational databases, and system design.
After completing this course, the student will be able to identify how the following programs are written with DB2:
- Report programs
- Data inquiry programs
- Data update programs
Preparing an Application Program with Embedded SQL
DB2 Precompiler and Coprocessor
Plans and Packages
Codes Returned from DB2 to an Application Program
Declaring Table Definitions
Host Variables that Pass Values between an Application Program and DB2
Using a Cursor
ROW and ROWSET Cursors
Commit Points and their Effect on Cursors
DB2 Rollbacks and How to Force One
Step by Step Process to Building a DB2 COBOL Program
Writing a DB2 COBOL Program by Using a Cursor
Writing a DB2 COBOL Update Program by Using a Cursor