Getting started with DB2 UDB CLI
To get started with DB2® UDB call level interface (CLI), know the basics of DB2 UDB CLI, how it compares to embedded SQL, and how to select the best interface for your programming needs.
It is important to understand what DB2 UDB CLI, or any callable SQL interface, is based on, and compare it with existing interfaces.
ISO standard 9075:1999 – Database Language SQL Part 3: Call-Level Interface provides the standard definition of CLI. The goal of this interface is to increase the portability of applications by enabling them to become independent of any one database server.
ODBC provides a Driver Manager for Windows®, which offers a central point of control for each ODBC driver (a dynamic link library (DLL) that implements ODBC function calls and interacts with a specific Database Management System (DBMS)).
Where to find answers to additional DB2 UDB CLI questions
An FAQ, which elaborates on some items discussed in this topic collection, is available on the IBM® DB2 Universal Database™ Web site
.
- Differences between DB2 UDB CLI and embedded SQL
DB2 UDB call level interface (CLI) and embedded SQL differ in many ways. - Advantages of using DB2 UDB CLI instead of embedded SQL
The DB2 UDB call level interface (CLI) has several key advantages over embedded SQL. - Deciding between DB2 UDB CLI, dynamic SQL, and static SQL
Which interfaces you choose depends on your application.