Application Development Guide

Database Manager APIs Used in Embedded SQL or DB2 CLI Programs

Your application can use APIs to access database manager facilities that are not available using SQL statements. For complete details on the APIs available with the database manager and how to call them, refer to the examples in the Administrative API Reference.

You can use the DB2 APIs to:

• Manipulate the database manager environment, which includes cataloging and uncataloging databases and nodes, and scanning database and node directories. You can also use APIs to create, delete, and migrate databases
• Provide facilities to import and export data, and administer, backup, and restore the database
• Manipulate the database manager configuration file and the database configuration files
• Provide operations specific to the client/server environment
• Provide the run-time interface for precompiled SQL statements. These APIs are not usually called directly by the programmer. Instead, they are inserted into the modified source file by the precompiler after processing.

The database manager includes APIs for language vendors who want to write their own precompiler, and other APIs useful for developing applications.

For complete details on the APIs available with the database manager and how to call them, see the examples in the Administrative API Reference.