SQL call level interface

Db2® for i call level interface (CLI) is a callable Structured Query Language (SQL) programming interface that is supported in all DB2® environments.

A callable SQL interface is a programming interface (API) for database access that uses function calls to run dynamic SQL statements.

Db2 for i CLI is an alternative to embedded dynamic SQL. The important difference between embedded dynamic SQL and Db2 for i CLI is how the SQL statements are run. On the IBM® i operating system, this interface is available to any of the Integrated Language Environment® (ILE) languages.

Db2 for i CLI also provides full Level 1 Microsoft Open Database Connectivity (ODBC) support, plus many Level 2 functions. For the most part, ODBC is a superset of the American National Standards Institute (ANSI) and ISO SQL CLI standard.

Note: By using the code examples, you agree to the terms of the Code license and disclaimer information.