The Call Level Interface (CLI) is an application programming interface (API)[1] and software standard to embed Structured Query Language (SQL) code in a host program[2] as defined in a joint standard by the International Organization for Standardization (ISO) and International Electrotechnical Commission (IEC): ISO/IEC 9075-3:2003.[3] 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 programming languages C and COBOL.
The interface is part of what The Open Group, publishes in a part of the X/Open Portability Guide, termed 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 efficiently. 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 Open Database Connectivity (ODBC) 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. Examples of languages that support Call Level Interface are ANSI C, C#, Visual Basic .NET (VB.NET), Java, Pascal, and Fortran.[4]
^"Chapter 1". Technical Standard - Data Management: SQL Call Level Interface (CLI). X/Open Company Ltd., U.K. 1995. p. 1. ISBN 1-85912-081-4.
^Stephens, Ryan; Plew, Ron; Jones, Arie (2011). Sams Teach Yourself SQL (5th ed.). Pearson Education. p. 349. ISBN 978-0672335419.
^"ISO/IEC 9075-3:2003". ISO. Retrieved 13 December 2014.
^Stephens, Ryan; Plew, Ron; Jones, Arie (2011). Sams Teach Yourself SQL (5th ed.). Pearson Education. p. 351. ISBN 978-0672335419.
and 21 Related for: Call Level Interface information
The CallLevelInterface (CLI) is an application programming interface (API) and software standard to embed Structured Query Language (SQL) code in a host...
A foreign function interface (FFI) is a mechanism by which a program written in one programming language can call routines or make use of services written...
C and C++), as well as requiring knowledge of the low-level binary interface for the system call operation, which may be subject to change over time and...
Technologies during the early 1990s, and became the basis for the CallLevelInterface (CLI) standardized by SQL Access Group in the Unix and mainframe...
In computing, the Oracle CallInterface (OCI) consists of a set of C-language software APIs which provide an interface to the Oracle database. OCI offers...
in machine code, which is a low-level, hardware-dependent format. In contrast, an application programming interface (API) defines this access in source...
standard that describes how to build or use such a connection or interface is called an API specification. A computer system that meets this standard...
CLI may refer to: CallLevelInterface, an SQL database management API Command-line interface, of a computer program Command-line interpreter or command...
use an interface description language (IDL) to let various platforms call the RPC. The IDL files can then be used to generate code to interface between...
are called brain–computer interfaces (BCIs) or brain–machine interfaces (BMIs). Other terms for human–machine interfaces are man–machine interface (MMI)...
standard The Open Trusted Technology Provider Standard (O-TTPS) The CallLevelInterface (the basis for ODBC) The Common Desktop Environment (CDE) The Distributed...
Serial Peripheral Interface (SPI) is a de facto standard (with many variants) for synchronous serial communication, used primarily in embedded systems...
Java-based rules engines provide a technical call-levelinterface, based on the JSR-94 application programming interface (API) standard, in order to allow for...
resources and services of the Linux kernel. It is composed of the system callinterface of the Linux kernel and the subroutines in the C standard library. The...
A graphical user interface, or GUI (/ˈɡuːi/ GOO-ee), is a form of user interface that allows users to interact with electronic devices through graphical...
Tandem, Sun and HP. The SAG started the development of the SQL CallLevelInterface which later was published as an X/Open specification. In 1992, Microsoft...
within COM is the creation of sub-objects to which method "calls" are delegated. COM is an interface technology defined and implemented as standard only on...
abstract interface which provides a set of primitives that are generally useful for drawing graphical objects. Application programming interface (API) Application...
multiple levels that it is no longer possible to make a change in one place without necessitating many additional changes. Using an interface or an abstract...
must provide a user interface that is capable of allowing a user to access and process content at multiple classification levels from one system. The...
The Intelligent Platform Management Interface (IPMI) is a set of computer interface specifications for an autonomous computer subsystem that provides...