Processing a DB2 UDB Database This course is also available on CD-ROM
Presenter: Manta Technologies
Availability: Online SKU: 3590
Course Description: This course describes the capabilities of an application that processes files in a DB2 UDB database. The course begins by describing the basic file options supported by DB2 UDB. 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 UDB 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 UDB database.
After completing this course, you should be able to: • Identify and describe the basic file operations supported by DB2 UDB • Identify what operations set and change file position • Describe how DB2 UDB indicates that an exception or error condition exists • Use the OVRDBF command to override a database file's attributes s • 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
Audience: This course is intended for programmers and application developers who will be creating applications that process a DB2 UDB database.
Prerequisites: This course assumes that you have a basic knowledge of OS/400 facilities. You can satisfy this prerequisite by successfully completing the Using an iSeries System series. It also assumes that you have a basic knowledge of DB2 UDB. You can satisfy this prerequisite by successfully completing the first course in the series, Introduction to DB2 UDB.
Course Outline: Processing Files in a High-Level Language Program Overriding Database File Processing Options Sharing Database Files Using the OPNQRYF Command
Course Details:
Length:
90 minutes
Format:
Online Learning
Publisher:
Manta
Processing a DB2 UDB Database This course is also available on CD-ROM
Processing a DB2 UDB Database
