Jump to content

Call Level Interface

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Nixdorf (talk | contribs) at 15:59, 22 January 2003. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

The Call Level Interface or CLI is a software de facto-standard API for SQL-based database management systems created by the Open Group (formerly the X/Open Company). The API is defined for C programming language and COBOL only.

The Call Level Interface defines how the C or COBOL program shall send SQL queries to the DBMS and how the returned recordsets shall be handled by the application in a consistent way.

The inteface is part of something the Open Group calls "CAE", "Common Application Environment", which is supposed 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.

The work with the Call Level Interface began i USA-based SQL Access Group, but was transferred to the X/Open Company in the fourth quarter 1994. It has properties that makes it larger than the ISO SQL CLI which has never had any widespread use.

The standard has the book number ISBN 1-85912-081-4 and the internal document number is C451.