Processing database files

Db2® for i provides various processing options for you to open, manipulate, and close database files. You can also monitor database file errors in your program.

Database file processing: Runtime considerations
Before a database file is opened for processing, you need to consider how you want to use the file in the program or job. A better understanding of the runtime file processing parameters can help you avoid unexpected results and improve the performance of your program.
Opening a database file
You can use the Open Query File (OPNQRYF) and Open Database File (OPNDBF) commands to open database file members in a program.
Basic database file operations in programs
Your program can perform read, update, write, and delete operations on database files.
Closing a database file
When your program completes processing a database file member, it should close the file. Closing a database file disconnects your program from the file.
Monitoring database file errors in a program
When your applications perform operations on database files, you need to monitor messages about file errors so as to take appropriate actions to prevent the errors.

Parent topic: Database programming