Call Level Interface

<h2 id="history">History</h2>
<p>The work with the Call Level Interface began in a subcommittee of the US-based <a href="/facts/SQL_Access_Group/o18bSjNj">SQL Access Group</a> (SAG)<a class="footnote-ref" id="fnref:5" href="#fn:5"><sup>5</sup></a><a class="footnote-ref" id="fnref:6" href="#fn:6"><sup>6</sup></a><a class="footnote-ref" id="fnref:7" href="#fn:7"><sup>7</sup></a> In 1992, it was initially published and marketed as <a href="/facts/Microsoft/nGIDDXdx">Microsoft</a>'s ODBC API. The CLI specification was submitted as to the ISO and <a href="/facts/American_National_Standards_Institute/p3d1TQCb">American National Standards Institute</a> (ANSI) standards committees in 1993. The standard has the book number <a href="/facts/ISBN_(identifier)/15AdSPa9">ISBN</a> 1-85912-081-4 and the internal document number is C451.
</p><p>ISO SQL/CLI is an addendum to 1992 SQL standard (<a href="/facts/SQL-92/a9th5tCf">SQL-92</a>). It was completed as ISO standard ISO/IEC 9075-3:1995 Information technology—Database languages—SQL—Part 3: Call-Level Interface (SQL/CLI).
</p><p>In the fourth quarter of 1994, control over the standard was transferred to the <a href="/facts/X/Open/btwVKbX2">X/Open</a> Company, which significantly expanded and updated it. The X/Open CLI interface is a superset of the ISO SQL CLI.
</p><p>SQL/CLI remains available in later editions such as ISO/IEC 9075-3:2003.
</p>
<h2 id="see-also">See also</h2>
<ul><li><a href="/facts/SQL/UjQLJcYm">SQL</a></li>
<li><a href="/facts/SQL:2003/V9GLzgLQ">SQL:2003</a></li>
<li><a href="/facts/Open_Database_Connectivity/2dV2Fm5j">Open Database Connectivity</a></li></ul>

<h2 id="external-links">External links</h2>
<ul><li><a href="https://publications.opengroup.org/c451">Online definition of CLI</a> at <a href="/facts/The_Open_Group/uRoDdEae">The Open Group</a> webpage</li></ul>

<h2 id="references">References</h2>

<ol>
<li id="fn:1"><p>"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. <a href="1-85912-081-4" target="_blank">1-85912-081-4</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li>
<li id="fn:2"><p>Stephens, Ryan; Plew, Ron; Jones, Arie (2011). Sams Teach Yourself SQL (5th ed.). Pearson Education. p. 349. ISBN 978-0672335419. <a href="978-0672335419" target="_blank">978-0672335419</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li>
<li id="fn:3"><p>"ISO/IEC 9075-3:2003". ISO. Retrieved 13 December 2014. <a href="http://www.iso.org/iso/iso_catalogue/catalogue_ics/catalogue_detail_ics.htm?csnumber=34134" target="_blank">http://www.iso.org/iso/iso_catalogue/catalogue_ics/catalogue_detail_ics.htm?csnumber=34134</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li>
<li id="fn:4"><p>Stephens, Ryan; Plew, Ron; Jones, Arie (2011). Sams Teach Yourself SQL (5th ed.). Pearson Education. p. 351. ISBN 978-0672335419. <a href="978-0672335419" target="_blank">978-0672335419</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></p></li>
<li id="fn:5"><p>"Call-Level Interface". FOLDOC: Free On-Line Dictionary of Computing. FOLDOC. Retrieved 13 December 2014. <a href="http://foldoc.org/Call-Level+Interface" target="_blank">http://foldoc.org/Call-Level+Interface</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></p></li>
<li id="fn:6"><p>"Call-level interface | Define Call-level interface at Dictionary.com". dictionary.reference.com. Archived from the original on 2013-01-01.
 <a href="https://web.archive.org/web/20130101113639/http://dictionary.reference.com/browse/call-level+interface" target="_blank">https://web.archive.org/web/20130101113639/http://dictionary.reference.com/browse/call-level+interface</a> <a href="#fnref:6" class="footnote-back-ref">↩</a></p></li>
<li id="fn:7"><p>"CLI Definition from PC Magazine Encyclopedia". PC Mag. Retrieved 13 December 2014. A database programming interface from the SQL Access Group (SAG), an SQL membership organization. <a href="https://www.pcmag.com/encyclopedia/term/39768/cli" target="_blank">https://www.pcmag.com/encyclopedia/term/39768/cli</a> <a href="#fnref:7" class="footnote-back-ref">↩</a></p></li>
</ol>

Call Level Interface open-in-new

Call Level Interface