Manta alt

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: 90 minutes

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.