Call Level Interface
||This article includes a list of references, related reading or external links, but its sources remain unclear because it lacks inline citations. (March 2013)|
The Call Level Interface (CLI) is a software standard defined in ISO/IEC 9075-3:2003. The Call Level Interface defines how a program should send SQL queries to the database management system (DBMS) and how the returned recordsets should be handled by the application in a consistent way. Developed in the early 1990s, the API was defined only for the C and COBOL programming languages.
The interface is part of what The Open Group refers to as the Common Application Environment, which is intended to be a wide standard for programming open applications, i.e. applications from different programming teams and different vendors that can interoperate in an efficient manner. SQL/CLI provides an international standard implementation-independent CLI to access SQL databases. Client-server tools can easily access databases through Dynamic-link libraries (DLL). It supports and encourages a rich set of client-server tools.
The most widespread use of the CLI standard is the basis of the ODBC (Open Database Connectivity) specification, which is widely used to allow applications to transparently access database systems from different vendors. The current version of the API, ODBC 3.52, incorporates features from both the ISO and X/Open standards (see below).
The work with the Call Level Interface began in a subcommittee of the US-based SQL Access Group. In 1992, it was initially published and marketed as Microsoft's ODBC API. The CLI specification was submitted as to the ISO and ANSI standards committees in 1993; the standard has the book number ISBN 1-85912-081-4 and the internal document number is C451.
ISO SQL/CLI is an addendum to 1992 SQL standard (SQL-92). It was completed as ISO standard ISO/IEC 9075-3:1995 Information technology -- Database languages -- SQL -- Part 3: Call-Level Interface (SQL/CLI). The current SQL/CLI effort is adding support for SQL3.
|This database-related article is a stub. You can help Wikipedia by expanding it.|