Module SQL: Difference between revisions
Moved page from wikipedia:en:Draft:Module SQL ([[Edithistory:|history]]) |
m Moved page from wikipedia:en:Draft:Module SQL ([[Edithistory:|history]]) |
||
| Line 28: | Line 28: | ||
== Database systems that support module SQL == | == Database systems that support module SQL == | ||
=== Microsoft SQL Server === | === [[Microsoft SQL Server]] === | ||
SQL modules is a technique among others for accessing the DBMS.<ref>{{cite web | SQL modules is a technique among others for accessing the [[DBMS]].<ref>{{cite web | ||
|url=https://learn.microsoft.com/en-us/sql/odbc/reference/sql-modules?view=sql-server-ver16 | |url=https://learn.microsoft.com/en-us/sql/odbc/reference/sql-modules?view=sql-server-ver16 | ||
|title=SQL Modules | |title=SQL Modules | ||
| Line 36: | Line 36: | ||
}}</ref> | }}</ref> | ||
=== Mimer SQL=== | === [[Mimer SQL]] === | ||
[[ | Mimer SQL for [[Linux]], [[macOS]], [[OpenVMS]] and [[Windows]] support module SQL.<ref>{{cite web | ||
|url=https://docs.mimer.com/MimerSqlManual/latest/Manuals/Module_SQL/Module_SQL.htm | |url=https://docs.mimer.com/MimerSqlManual/latest/Manuals/Module_SQL/Module_SQL.htm | ||
|title=Module SQL|publisher=[[Mimer SQL]] | |title=Module SQL|publisher=[[Mimer SQL]] | ||
|work=Mimer SQL Programmer's Manual latest version, Module SQL}}</ref> | |work=Mimer SQL Programmer's Manual latest version, Module SQL}}</ref> | ||
; C/C++ | ; [[C (programming language)|C]]/[[C++]] | ||
: Module SQL for C/C++ is supported on Linux, macOS, OpenVMS and Windows. | : Module SQL for C/C++ is supported on Linux, macOS, OpenVMS and Windows. | ||
; COBOL | ; [[COBOL]] | ||
: Module SQL for COBOL is supported on OpenVMS. | : Module SQL for COBOL is supported on OpenVMS. | ||
; Fortran | ; [[Fortran]] | ||
: Module SQL for Fortran is supported on OpenVMS. | : Module SQL for Fortran is supported on OpenVMS. | ||
; Pascal | ; [[Pascal (programming language)|Pascal]] | ||
: Module SQL for Pascal is supported on OpenVMS. | : Module SQL for Pascal is supported on OpenVMS. | ||
=== Oracle Database === | === [[Oracle Database]] === | ||
; Ada | ; [[Ada (programming language)|Ada]] | ||
: Starting with Oracle8, SQL*Module uses Ada but appears to have not been updated since.<ref>{{cite web | : Starting with Oracle8, SQL*Module uses Ada but appears to have not been updated since.<ref>{{cite web | ||
|url=http://download.oracle.com/docs/cd/B10501_01/server.920/a96530/migcompa.htm#1010868 | |url=http://download.oracle.com/docs/cd/B10501_01/server.920/a96530/migcompa.htm#1010868 | ||
Revision as of 13:52, 5 June 2023
Module SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Module SQL statements are SQL statements written in an SQL client module, that can be called as routines from the host language program source code like a host language routine. An SQL standard Module Language file is compiled into calls to a SQL runtime library that interacts with the Database management system. This allows programmers to call SQL statements from programs written in any number of languages such as C/C++, Ada, COBOL and Fortran. Module SQL is closely related to Embedded SQL.
Using Module Language is very straightforward: place all SQL code in a separate module, and define an interface between the module containing the SQL code and the host program.[1] The SQL standard defines an SQL module as an SQL client module and the language in which SQL queries are called is referred to as the host language. A popular host language is C.
The SQL standard 2016 is available through purchase and contains chapter 13 SQL-client modules and its syntax rules.[2]
Database systems that support module SQL
Microsoft SQL Server
SQL modules is a technique among others for accessing the DBMS.[3]
Mimer SQL
Mimer SQL for Linux, macOS, OpenVMS and Windows support module SQL.[4]
- C/C++
- Module SQL for C/C++ is supported on Linux, macOS, OpenVMS and Windows.
- COBOL
- Module SQL for COBOL is supported on OpenVMS.
- Fortran
- Module SQL for Fortran is supported on OpenVMS.
- Pascal
- Module SQL for Pascal is supported on OpenVMS.
Oracle Database
- Ada
- Starting with Oracle8, SQL*Module uses Ada but appears to have not been updated since.[5] SQL*Module is a module language that supports the Ada83 language standard for Ada.
References
- ↑ "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.
- ↑ "SQL Standard 2016 Chapter 13 SQL-client modules". ISO/IEC 9075-2:2016 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation). ISO. Retrieved 2023-03-30.
- ↑ "SQL Modules". Microsoft. Retrieved 2023-03-30.
- ↑ "Module SQL". Mimer SQL Programmer's Manual latest version, Module SQL. Mimer SQL.
- ↑ "Ada Support in Version 8". Oracle9i Database Migration, Release 2 (9.2), Chapter 5. Compatibility and Interoperability. Oracle Corporation. Retrieved 2023-03-30.
External links
This article "Module SQL" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:Module SQL. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.
