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
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
Processing Files in a High-Level Language Program
Overriding Database File Processing Options
Sharing Database Files
Using the OPNQRYF Command
This course is intended for programmers and application developers who will be creating applications that process a DB2 database.
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.