Getting started with DB2 for i CLI

To get started with DB2® for i CLI , you must know the basics of DB2 for i 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 for i 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)).