- Home
- Catalog
- Courses
- Database Curriculum
- Create and Maintain DB2 Programs
Create and Maintain DB2 Programs
Duration
3 to 4 hours
Overview
Audience
Programmers and DBAs requiring training in writing application programs to reference and update DB2 data, particularly in the mainframe environment
Prerequisites
Completion of the courses Manage Data Definitions with DB2 and Manage Data with DB2 SQL, and basic knowledge of DB2, relational databases, and system design
Objectives
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
Course Content
Embedding SQL in an Application Program
Steps Required to Prepare an Application Program With Embedded SQL for Execution
Manipulating Data and Components of an Application Program
Codes Returned From DB2 to an Application Program
Host Variables That Pass Values Between an Application Program and DB2
Cursors
The Cursor
The Scrollable Cursor
Commit Points and Save Points
Commit Points and their Effect On Cursor
DB2 Rollbacks and How to Force One
Save Points
Writing a DB2 COBOL Program
Build A Program That Issues Simple SQL Statements to DB2
Writing a DB2 COBOL Cursor Update Program
Writing a DB2 COBOL Program By Using a Cursor
Writing a DB2 COBOL Update Program By Using a Cursor
Create and Maintain DB2 UDB Programs Mastery Test
Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at 770-872-4278
