SQL Reference

DB2 Call Level Interface (CLI)

The DB2 Call Level Interface is an application programming interface in which functions are provided to application programs to process dynamic SQL statements. CLI programs can also be compiled using an Open Database Connectivity (ODBC) software developer's kit, enabling them to access ODBC data sources. Through the interface, applications use procedure calls at execution time to connect to databases, to issue SQL statements, and to get returned data and status information. Unlike using embedded SQL, no precompilation is required. Applications developed using this interface may be executed on a variety of databases without being compiled against each of the databases.

The DB2 CLI interface provides many features not available in embedded SQL. A few of these are:

CLI provides function calls which support a consistent way to query and retrieve database system catalog information across the DB2 family of database management systems. This reduces the need to write database server specific catalog queries.
CLI provides support for scrollable cursors.
Stored procedures called from application programs written using CLI can return result sets to those programs.

The CLI Guide and Reference describes the APIs supported with this interface.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]