Processing database files

 

DB2 Universal Database™ for iSeries™ 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, 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, monitor messages about file errors so as to take appropriate actions to prevent the errors.

 

Parent topic:

Database programming