Call Level Interface

Call Level Interface

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. It supports and encourages a rich set of client-server tools.

The most widespread use of the CLI standard is as 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).

History

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.

In the fourth quarter of 1994, control over the standard was transferred to the X/Open Company, which significantly expanded and updated it. The X/Open CLI interface is a superset of the ISO SQL CLI.

External links

* [http://www.opengroup.org/products/publications/catalog/c451.htm Online definition of CLI] at the Open Groups webpage


Wikimedia Foundation. 2010.

Игры ⚽ Поможем решить контрольную работу

Look at other dictionaries:

  • Call Level Interface — (CLI) (рус. Интерфейс уровня вызовов) программный стандарт, закрепленный в документе ISO/IEC 9075 3:2003. CLI описывает как именно программа должна отправлять SQL запросы к системе управления базами данных (СУБД) и как именно возвращенный набор… …   Википедия

  • Call Level Interface — Das Call Level Interface (kurz CLI) ist eine Datenbankschnittstellen Spezifikation für den Zugriff auf relationale Datenbanken aus anderen Anwendungen heraus. Bei konkreten Implementierungen des CLI handelt es sich um so genannte Middleware, mit… …   Deutsch Wikipedia

  • Call Level Interface — En informatique, la Call Level Interface (traduction: interface de niveau appels) est une interface de programmation normalisée de multibases qui permet à des applications informatiques de manipuler des bases de données mises à disposition par… …   Wikipédia en Français

  • Call of Cthulhu: Dark Corners of the Earth — Developer(s) Headfirst Productions Publisher(s) …   Wikipedia

  • Interface (computing) — For other uses, see Interface. In the field of computer science, an interface is a tool and concept that refers to a point of interaction between components, and is applicable at the level of both hardware and software. This allows a component,… …   Wikipedia

  • Call centre — A very large collections call centre in Lakeland, Florida. A call centre or call center is a centralised office used for the purpose of receiving and transmitting a large volume of requests by telephone. A call centre is operated by a company to… …   Wikipedia

  • Level (video gaming) — This article is about video game settings. For character levels, see Level up. For other uses, see Level (disambiguation). A level, map, area, or world in a video game is the total space available to the player during the course of completing a… …   Wikipedia

  • Multiple document interface — Graphical computer applications with a multiple document interface (MDI) are those whose windows reside under a single parent window (usually except for modal windows), as opposed to all windows being separate from each other (single document… …   Wikipedia

  • Application binary interface — In computer software, an application binary interface (ABI) describes the low level interface between an application program and the operating system, or the interface between an application and its libraries, or that between component parts of… …   Wikipedia

  • Foreign function interface — A foreign function interface (or abbr|FFI|Foreign Function Interface) is a mechanism by which a program written in one programming language can call routines or make use of services written in another. The term comes from the specification for… …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”