The call level interface (CLI) is
a C and C++ application programming interface for relational database
access that uses function calls to pass dynamic SQL statements as
function arguments. You can enable a CLI application that connects
to a DB2® database or Informix® database with client
optimization, and then you can control the SQL statements that are
issued by the application.
For example, if the application
connects to a DB2 database,
you can configure the application to run SQL statements statically
against the database. You can control the SQL statements that are
allowed to run against the database.
When you enable and configure a CLI application with pureQuery
client optimization, pureQuery Runtime provides benefits that include:
- Providing a simple mechanism that adds few artifacts to the application
development and deployment process.
- Allowing changes to be made in the dynamic SQL to static SQL mapping
when connected to a DB2 database.
- Simplifying the binding and administration of static SQL packages
that are executed by the application when connected to a DB2 database.
- Enabling easier end-to-end development, monitoring, and runtime
problem determination of the application.
Although CLI applications are C and C++ applications, you use the
Java-based pureQuery utilities Configure and StaticBinder to enable
CLI applications that are enabled with pureQuery client optimization
to run SQL statements statically.