You can enable a CLI or .NET application
that connects to a DB2® database
or Informix® database with
client optimization. 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.
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.
The .NET Framework is a Microsoft software
development platform. The .NET Framework supports several programming
languages. The .NET Framework class library provides the building
blocks with which you build .NET applications.
When you enable and configure a CLI or .NET 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.
- Providing the ability to store and retrieve pureQuery Runtime artifacts from a repository.
- 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.
You use the Java based pureQuery utilities
Configure, StaticBinder, and ManageRepository to enable CLI and .NET
applications that are enabled with pureQuery client
optimization to run SQL statements statically.