YOUR IBM i TRAINING SOURCE

You must allow the browser to execute JavaScript programs if you want to view product information. If your browser is set up to execute JavaScript programs, the problem is that the product ID was incorrect. Use the menu bar above to find the desired product.

Overview

This course describes the capabilities of an application that processes files in a DB2 database. The course begins by describing the basic file options supported by DB2. It then shows how to use the OVRDBF command to override the file processing options in effect for a program. You will next see how programs running in the same job can share an open data path (ODP) to a DB2 file. This discussion includes descriptions of the OPNDBF and CLOF commands. The course ends by showing how to use the OPNQRYF command to create an alternative view of the data in a DB2 database.

Approximate Study Time: 3 hours

Objectives

After completing this course, you should be able to:

Identify and describe the basic file options supported by DB2
Identify what operations set and change file position
Describe how DB2 indicates to an application program that an exception or error condition exists
Use the OVRDBF command to override a database file's attributes and an application program's file processing options
List the benefits provided by a shared open data path
Use the OPNDBF command to open a shared database file
Use the CLOF command to close a shared database file
Use the OPNQRYF command to define an alternative view of the data in a database

Topic Outline

Processing Files in a High-Level Language Program

Overriding Database File Processing Options

Sharing Database Files

Using the OPNQRYF Command

Audience

This course is intended for programmers and application developers who will be creating applications that process a DB2 database.

Prerequisites

This course assumes that you have a basic knowledge of IBM i facilities. You can satisfy this prerequisite by successfully completing the Introduction to the IBM i Environment series. It also assumes that you have a basic knowledge of DB2. You can satisfy this prerequisite by successfully completing the first course in the series, Introduction to DB2.