Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Module SQL
open-in-new
<h2 id="sql-standard-compliance">SQL Standard Compliance</h2> <p>The <a href="/facts/SQL%3a2023/z4NTEYrc">SQL:2023</a> standard (ISO/IEC 9075-2:2023 Information technology — Database languages SQL — Part 2: Foundation (SQL/Foundation), chapter 13<a class="footnote-ref" id="fnref:3" href="#fn:3"><sup>3</sup></a>) defines an SQL module as an <i>SQL client module</i>, and the language in which SQL queries are called is referred to as the <i>host language</i>. Specified host languages are: </p> <ul><li><a href="/facts/Ada_(programming_language)/Y2yHel4l">Ada</a> - Feature B111, “Module language Ada”</li> <li><a href="/facts/C_(programming_language)/Ky2No763">C</a> - Feature B112, “Module language C”</li> <li><a href="/facts/COBOL/wVnhqs0k">COBOL</a> - Feature B113, “Module language COBOL”</li> <li><a href="/facts/Fortran/m1KqjcMU">Fortran</a> - Feature B114, “Module language Fortran”</li> <li><a href="/facts/MUMPS/06E3hkoE">MUMPS</a> - Feature B115, “Module language MUMPS”</li> <li><a href="/facts/Pascal_(programming_language)/b3yvp8bF">Pascal</a> - Feature B116, “Module language Pascal”</li> <li><a href="/facts/PL%2fI/469mVYgd">PL/I</a> - Feature B117, “Module language PL/I”</li></ul> <p>(All the languages listed above are optional features, which means that each vendor can decide which language(s) to support.) </p> <h2 id="database-systems-that-support-module-sql">Database systems that support module SQL</h2> <h3><a href="/facts/Mimer_SQL/88K5koLW">Mimer SQL</a></h3> <p>Mimer SQL 11.0 and later for <a href="/facts/Linux/9FvCKSTq">Linux</a>, <a href="/facts/MacOS/Y93vVpTm">macOS</a>, <a href="/facts/OpenVMS/rAnHAgpD">OpenVMS</a> and <a href="/facts/Windows/bwhAhuSL">Windows</a> support module SQL for C/C++, and Mimer SQL for <a href="/facts/OpenVMS/rAnHAgpD">OpenVMS</a> also supports module SQL for COBOL, Fortran and Pascal.<a class="footnote-ref" id="fnref:4" href="#fn:4"><sup>4</sup></a> </p> <h3><a href="/facts/Oracle_Database/FHv5g732">Oracle Database</a></h3> <p>Oracle 8.0 supported SQL*Module for Ada but support has been removed in later versions.<a class="footnote-ref" id="fnref:5" href="#fn:5"><sup>5</sup></a> SQL*Module is a module language that supports the Ada83 language standard for Ada.<a class="footnote-ref" id="fnref:6" href="#fn:6"><sup>6</sup></a> </p> <h3><a href="/facts/Oracle_Rdb/C6EXRgAd">Oracle Rdb</a></h3> <p>Supported host languages are Ada, <a href="/facts/BASIC/VYMl5TmA">BASIC</a>, C, COBOL, Fortran, Pascal and PL/I.<a class="footnote-ref" id="fnref:7" href="#fn:7"><sup>7</sup></a> </p> <h2 id="external-links">External links</h2> <ul><li><a href="https://docs.oracle.com/cd/B10501_01/appdev.920/a58231/ch2.htm">SQL*Module for Ada Programmer's Guide, Release 8.0</a></li> <li><a href="https://developer.mimer.com/article/module-sql/">Module SQL, Mimer SQL Developer</a></li></ul> <h2 id="references">References</h2> <ol> <li id="fn:1"><p>"The Module Language Concept". SQL*Module for Ada Programmer's Guide, Release 8.0, Chapter 1. Introduction to SQL*Module. Oracle Corporation. Retrieved 2023-03-30. <a href="http://download.oracle.com/docs/cd/B10501_01/appdev.920/a58231/ch1.htm#2889" target="_blank">http://download.oracle.com/docs/cd/B10501_01/appdev.920/a58231/ch1.htm#2889</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li> <li id="fn:2"><p>Oppel, Andrew (November 2015). SQL: A Beginner's Guide, Fourth Edition, 4th Edition (4th ed.). McGraw-Hill. p. 544. ISBN 978-0071842594. <a href="978-0071842594" target="_blank">978-0071842594</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li> <li id="fn:3"><p>"SQL Standard 2023, Chapter 13 SQL-client modules". ISO/IEC 9075-2:2023 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation). ISO. Retrieved 2023-06-05. <a href="https://www.iso.org/standard/76584.html" target="_blank">https://www.iso.org/standard/76584.html</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li> <li id="fn:4"><p>"Module SQL". Mimer SQL Programmer's Manual latest version, Module SQL. Mimer SQL. <a href="https://docs.mimer.com/MimerSqlManual/latest/Manuals/Module_SQL/Module_SQL.htm" target="_blank">https://docs.mimer.com/MimerSqlManual/latest/Manuals/Module_SQL/Module_SQL.htm</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></p></li> <li id="fn:5"><p>"SQL*Module™ for Ada - Programmer's Guide" (PDF). Oracle Corporation. Retrieved 2023-06-19. <a href="https://docs.oracle.com/cd/A87860_01/doc/appdev.817/a58231.pdf" target="_blank">https://docs.oracle.com/cd/A87860_01/doc/appdev.817/a58231.pdf</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></p></li> <li id="fn:6"><p>"Ada Support in Version 8". Oracle9i Database Migration, Release 2 (9.2), Chapter 5. Compatibility and Interoperability. Oracle Corporation. Retrieved 2023-03-30. <a href="http://download.oracle.com/docs/cd/B10501_01/server.920/a96530/migcompa.htm#1010868" target="_blank">http://download.oracle.com/docs/cd/B10501_01/server.920/a96530/migcompa.htm#1010868</a> <a href="#fnref:6" class="footnote-back-ref">↩</a></p></li> <li id="fn:7"><p>"Oracle Rdb7™, Guide to SQL Programming" (PDF). Oracle Corporation. Retrieved 2023-06-05. <a href="https://download.oracle.com/otn_hosted_doc/rdb/pdf/gsp.pdf" target="_blank">https://download.oracle.com/otn_hosted_doc/rdb/pdf/gsp.pdf</a> <a href="#fnref:7" class="footnote-back-ref">↩</a></p></li> </ol>