Chapter 11. CLI/ODBC Applications

This chapter explores Call Level Interfaces as provided by IBM's DB2 CLI and Microsoft's ODBC. IBM's CLI provides a library (or driver) of DBMS functions that can be used to access a DB2 database. Microsoft's ODBC provides a standard of functions that can be used to access a vendor's DBMS such as DB2. Both CLI and ODBC were originally based on parts of the X/Open CLI Standard. Much of the X/Open CLI Standard has been accepted as part of the ISO CLI Standard (ISO/IEC 9075-3:1995 SQL/CLI). ODBC 3.51 does contain considerable functionality that is not part of the ISO standard, much of which is being added to the next draft.

Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.