Using interfaces
Intelligent Miner® provides a set of user-defined methods, functions, and stored procedures to Db2. You invoke these database objects by using SQL statements.
- Call Level Interface (CLI)
- The Db2 CLI is
a C and C++ application programming interface for database access that provides a standard set of
functions to process SQL statements at run time. The Db2 CLI does not
require you to precompile or bind applications.
For further information about the Db2 CLI, refer to the platform-specific guide and reference.
- Java™ Database Connectivity (JDBC)
- JDBC is an SQL application programming interface between Java application programs and database management systems like Db2. It manages the
connection with a database, executes SQL statements, and retrieves their results.
For further information about JDBC, see Java SE Technologies - Database.
- Open Database Connectivity (ODBC)
- ODBC is a Microsoft database application programming interface for C that enables access to database management systems by using callable SQL. ODBC does not require the use of an SQL preprocessor. In addition, ODBC provides an architecture that lets users add modules called database drivers. These database drivers link the application to database management systems of their choice at run time.
- Embedded SQL
- Embedded SQL provides a way of including SQL code into application programming languages.
The use of embedded SQL requires precompilation and binding. Precompilation converts SQL statements into Db2 run-time API calls. Binding creates a package from a bind file, which contains information on the SQL statements in the application program.
For further information about embedded SQL, refer to the IBM® Db2 Application Development Guide.
- Db2 command line
- The Db2 command
line lets you interactively enter SQL statements for immediate execution. You can use this interface
to issue SQL statements with encapsulated Intelligent
Miner method and function calls.
For further information about issuing SQL statements from the Db2 command line, refer to your SQL documentation.
The Db2 SQL interface supports the development of data mining modeling applications in programming languages that support at least one of these interfaces.
The following sections briefly describe these interfaces, and give references to further information about them. Most of these interfaces are also described in greater detail in Db2 SQL Reference.