Module SQL - Revision history

WikiMasterBot2: automatic correction by IA

2026-05-01T01:44:57Z

automatic correction by IA

← Older revision		Revision as of 01:44, 1 May 2026
Line 7:		Line 7:
	----		----

			'''Module SQL''' is a method of combining the [[computing]] power of a [[programming language]] and the [[database]] [[Data Manipulation Language\|manipulation]] capabilities of [[SQL]]. Module SQL [[statement (programming)\|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 [[compiler\|compiled]] into calls to a SQL runtime library that interacts with the [[DBMS\|Database management system]]. This allows programmers to call SQL statements from applications written in regular programming languages.

	'''Module SQL''' is a method of combining the [[computing]] power of a [[programming language]] and the [[database]] [[Data Manipulation Language\|manipulation]] capabilities of [[SQL]]. Module SQL [[statement (programming)\|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 [[compiler\|compiled]] into calls to a SQL runtime library that interacts with the [[DBMS\|Database management system]]. This allows programmers to call SQL statements from applications written in regular programming languages.

	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.<ref name="modulelang">		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.<ref name="modulelang">
Line 19:		Line 17:
	\|accessdate=2023-03-30}}</ref>		\|accessdate=2023-03-30}}</ref>

	Module SQL is closely related to [[Embedded SQL]]. "SQL client modules are self-contained collections of SQL statements. Unlike embedded SQL, in which the SQL statements are inserted into the host programming language, SQL client modules are separate from the host language. The host language contains calls that invoke the module, which in turn executes the SQL statements within that module."<ref>{{cite book \|last1=Oppel \|first1=Andrew \|title=SQL: A Beginner's Guide, Fourth ~~Edition, 4th~~ Edition \|date=November 2015 \|publisher=McGraw-Hill \|isbn=978-0071842594 \|pages=544 \|edition=4th \|url=https://learning.oreilly.com/library/view/sql-a-beginners/9780071842570/ch18.html#:-:text=Create%20SQL%20Client%20Modules}}</ref>		Module SQL is closely related to [[Embedded SQL]]. "SQL client modules are self-contained collections of SQL statements. Unlike embedded SQL, in which the SQL statements are inserted into the host programming language, SQL client modules are separate from the host language. The host language contains calls that invoke the module, which in turn executes the SQL statements within that module."<ref>{{cite book \|last1=Oppel \|first1=Andrew \|title=SQL: A Beginner's Guide, Fourth Edition \|date=November 2015 \|publisher=McGraw-Hill \|isbn=978-0071842594 \|pages=544 \|edition=4th \|url=https://learning.oreilly.com/library/view/sql-a-beginners/9780071842570/ch18.html#:-:text=Create%20SQL%20Client%20Modules}}</ref>

	===SQL Standard Compliance===		===SQL Standard Compliance===
Line 45:		Line 43:
	Mimer SQL 11.0 and later for [[Linux]], [[macOS]], [[OpenVMS]] and [[Windows]] support module SQL for C/C++, and Mimer SQL for [[OpenVMS]] also supports module SQL for COBOL, Fortran and Pascal.<ref>{{cite web		Mimer SQL 11.0 and later for [[Linux]], [[macOS]], [[OpenVMS]] and [[Windows]] support module SQL for C/C++, and Mimer SQL for [[OpenVMS]] also supports module SQL for COBOL, Fortran and Pascal.<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>

WikiMasterBot2: Restauration de la révision ID 3652584 (plus long contenu)

2025-01-17T10:08:37Z

Restauration de la révision ID 3652584 (plus long contenu)

← Older revision		Revision as of 10:08, 17 January 2025
Line 1:		Line 1:
	{{Kept on Wikipedia}}		{{Short description\|Computer programming method}}
			{{Draft topics\|software\|computing\|technology}}
			{{AfC topic\|stem}}
			{{AfC submission\|\|\|ts=20230607143145\|u=Fjerdingen\|ns=118}}
			{{AFC comment\|1=In-depth coverage in independent secondary sources are required. [[User:Stuartyeates\|Stuartyeates]] ([[User talk:Stuartyeates\|talk]]) 19:21, 10 May 2023 (UTC)}}

			----



			'''Module SQL''' is a method of combining the [[computing]] power of a [[programming language]] and the [[database]] [[Data Manipulation Language\|manipulation]] capabilities of [[SQL]]. Module SQL [[statement (programming)\|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 [[compiler\|compiled]] into calls to a SQL runtime library that interacts with the [[DBMS\|Database management system]]. This allows programmers to call SQL statements from applications written in regular programming languages.

			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.<ref name="modulelang">
			{{cite web
			\|url=http://download.oracle.com/docs/cd/B10501_01/appdev.920/a58231/ch1.htm#2889
			\|title=The Module Language Concept
			\|work=SQLModule for Ada Programmer's Guide, Release 8.0, Chapter 1. Introduction to SQLModule
			\|publisher=[[Oracle Corporation]]
			\|accessdate=2023-03-30}}</ref>

			Module SQL is closely related to [[Embedded SQL]]. "SQL client modules are self-contained collections of SQL statements. Unlike embedded SQL, in which the SQL statements are inserted into the host programming language, SQL client modules are separate from the host language. The host language contains calls that invoke the module, which in turn executes the SQL statements within that module."<ref>{{cite book \|last1=Oppel \|first1=Andrew \|title=SQL: A Beginner's Guide, Fourth Edition, 4th Edition \|date=November 2015 \|publisher=McGraw-Hill \|isbn=978-0071842594 \|pages=544 \|edition=4th \|url=https://learning.oreilly.com/library/view/sql-a-beginners/9780071842570/ch18.html#:-:text=Create%20SQL%20Client%20Modules}}</ref>

			===SQL Standard Compliance===

			The [[SQL:2023]] standard (ISO/IEC 9075-2:2023 Information technology — Database languages SQL — Part 2: Foundation (SQL/Foundation), chapter 13<ref>{{cite web
			\|url=https://www.iso.org/standard/76584.html
			\|title=SQL Standard 2023, Chapter 13 SQL-client modules
			\|work=ISO/IEC 9075-2:2023 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
			\|publisher=[[ISO]]
			\|accessdate=2023-06-05
			}}</ref>) 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''. Specified host languages are:

			* [[Ada_(programming_language)\|Ada]] - Feature B111, “Module language Ada”
			* [[C_(programming_language)\|C]] - Feature B112, “Module language C”
			* [[COBOL]] - Feature B113, “Module language COBOL”
			* [[Fortran]] - Feature B114, “Module language Fortran”
			* [[MUMPS]] - Feature B115, “Module language MUMPS”
			* [[Pascal_(programming_language)\|Pascal]] - Feature B116, “Module language Pascal”
			* [[PL/I]] - Feature B117, “Module language PL/I”

			(All the languages listed above are optional features, which means that each vendor can decide which language(s) to support.)

			== Database systems that support module SQL ==
			=== [[Mimer SQL]] ===
			Mimer SQL 11.0 and later for [[Linux]], [[macOS]], [[OpenVMS]] and [[Windows]] support module SQL for C/C++, and Mimer SQL for [[OpenVMS]] also supports module SQL for COBOL, Fortran and Pascal.<ref>{{cite web
			\|url=https://docs.mimer.com/MimerSqlManual/latest/Manuals/Module_SQL/Module_SQL.htm
			\|title=Module SQL\|publisher=[[Mimer SQL]]
			\|work=Mimer SQL Programmer's Manual latest version, Module SQL}}</ref>

			=== [[Oracle Database]] ===
			Oracle 8.0 supported SQL*Module for Ada but support has been removed in later versions.<ref>{{cite web
			\|url=https://docs.oracle.com/cd/A87860_01/doc/appdev.817/a58231.pdf
			\|title=SQL*Module™ for Ada - Programmer's Guide
			\|work=SQL*Module™ for Ada - Programmer's Guide
			\|publisher=Oracle Corporation
			\|accessdate=2023-06-19
			}}</ref> SQL*Module is a module language that supports the Ada83 language standard for Ada.<ref>{{cite web
			\|url=http://download.oracle.com/docs/cd/B10501_01/server.920/a96530/migcompa.htm#1010868
			\|title=Ada Support in Version 8
			\|work=Oracle9i Database Migration, Release 2 (9.2), Chapter 5. Compatibility and Interoperability
			\|publisher=Oracle Corporation
			\|accessdate=2023-03-30
			}}</ref>

			=== [[Oracle_Rdb\|Oracle Rdb]] ===
			Supported host languages are Ada, [[BASIC]], C, COBOL, Fortran, Pascal and PL/I.<ref>{{cite web
			\|url=https://download.oracle.com/otn_hosted_doc/rdb/pdf/gsp.pdf
			\|title=Oracle Rdb7™, Guide to SQL Programming
			\|publisher=Oracle Corporation
			\|accessdate=2023-06-05
			}}</ref>

			== References ==
			<references/>

			== External links ==
			* [https://docs.oracle.com/cd/B10501_01/appdev.920/a58231/ch2.htm SQL*Module for Ada Programmer's Guide, Release 8.0]
			* [https://developer.mimer.com/article/module-sql/ Module SQL, Mimer SQL Developer]

			[[Category:SQL]]
			[[Category:Declarative programming languages]]
			[[Category:Query languages]]
			[[Category:Data modeling languages]]
			[[Category:Database APIs]]
			[[Category:SQL data access]]
			{{⚠️🚨COPIED from EverybodyWiki ❗❕⚠️😡😤Please respect Licence CC-BY-SA ❗}}
			{{Source Wikipedia}}
			{{Kept on Wikipedia\|Biggest version}}

WikiMasterBot2: WikiMasterBot2 moved page Kept on Wikipedia:Module SQL to Module SQL without leaving a redirect: move to main NS

2025-01-12T00:58:27Z

WikiMasterBot2 moved page Kept on Wikipedia:Module SQL to Module SQL without leaving a redirect: move to main NS

← Older revision	Revision as of 00:58, 12 January 2025
(No difference)

WikiMasterBot2: WikiMasterBot2 moved page Module SQL to Kept on Wikipedia:Module SQL without leaving a redirect: kept on Wikipedia

2024-01-15T14:38:14Z

WikiMasterBot2 moved page Module SQL to Kept on Wikipedia:Module SQL without leaving a redirect: kept on Wikipedia

← Older revision	Revision as of 14:38, 15 January 2024
(No difference)

WikiMasterBot2: A page with same name was found on Wikipedia. Feel free to revert this edit and add the template {{nobots}} anywhere to keep this article (history)

2024-01-15T14:38:04Z

A page with same name was found on Wikipedia. Feel free to revert this edit and add the template {{nobots}} anywhere to keep this article (history)

← Older revision		Revision as of 14:38, 15 January 2024
Line 1:		Line 1:
	{{~~Short description\|Computer programming method}}~~		{{Kept on Wikipedia}}
	~~{{Draft topics\|software\|computing\|technology}}~~
	~~{{AfC topic\|stem}}~~
	~~{{AfC submission\|\|\|ts=20230607143145\|u=Fjerdingen\|ns=118}}~~
	~~{{AFC comment\|1=In-depth coverage in independent secondary sources are required. [[User:Stuartyeates\|Stuartyeates]] ([[User talk:Stuartyeates\|talk]]) 19:21, 10 May 2023 (UTC)}}~~

	~~----~~



	'''Module SQL''' is a method of combining the [[computing]] power of a [[programming language]] and the [[database]] [[Data Manipulation Language\|manipulation]] capabilities of [[SQL]]. Module SQL [[statement (programming)\|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 [[compiler\|compiled]] into calls to a SQL runtime library that interacts with the [[DBMS\|Database management system]]. This allows programmers to call SQL statements from applications written in regular programming languages.

	~~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.<ref name="modulelang">~~
	~~{{cite web~~
	~~\|url=http://download.oracle.com/docs/cd/B10501_01/appdev.920/a58231/ch1.htm#2889~~
	~~\|title=The Module Language Concept~~
	~~\|work=SQLModule for Ada Programmer's Guide, Release 8.0, Chapter 1. Introduction to SQLModule~~
	~~\|publisher=[[Oracle Corporation]]~~
	~~\|accessdate=2023-03-30}}</ref>~~

	Module SQL is closely related to [[Embedded SQL]]. "SQL client modules are self-contained collections of SQL statements. Unlike embedded SQL, in which the SQL statements are inserted into the host programming language, SQL client modules are separate from the host language. The host language contains calls that invoke the module, which in turn executes the SQL statements within that module."<ref>{{cite book \|last1=Oppel \|first1=Andrew \|title=SQL: A Beginner's Guide, Fourth Edition, 4th Edition \|date=November 2015 \|publisher=McGraw-Hill \|isbn=978-0071842594 \|pages=544 \|edition=4th \|url=https://learning.oreilly.com/library/view/sql-a-beginners/9780071842570/ch18.html#:-:text=Create%20SQL%20Client%20Modules}}</ref>

	~~===SQL Standard Compliance===~~

	~~The [[SQL:2023]] standard (ISO/IEC 9075-2:2023 Information technology — Database languages SQL — Part 2: Foundation (SQL/Foundation), chapter 13<ref>{{cite web~~
	~~\|url=https://www.iso.org/standard/76584.html~~
	~~\|title=SQL Standard 2023, Chapter 13 SQL-client modules~~
	~~\|work=ISO/IEC 9075-2:2023 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)~~
	~~\|publisher=[[ISO]]~~
	~~\|accessdate=2023-06-05~~
	~~}}</ref>) 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''. Specified host languages are:~~

	* [[Ada_(programming_language)\|Ada]] - Feature B111, “Module language Ada”
	* [[C_(programming_language)\|C]] - Feature B112, “Module language C”
	* [[COBOL]] - Feature B113, “Module language COBOL”
	* [[Fortran]] - Feature B114, “Module language Fortran”
	* [[MUMPS]] - Feature B115, “Module language MUMPS”
	* [[Pascal_(programming_language)\|Pascal]] - Feature B116, “Module language Pascal”
	* [[PL/I]] - Feature B117, “Module language PL/I”

	~~(All the languages listed above are optional features, which means that each vendor can decide which language(s) to support.)~~

	~~== Database systems that support module SQL ==~~
	~~=== [[Mimer SQL]] ===~~
	Mimer SQL 11.0 and later for [[Linux]], [[macOS]], [[OpenVMS]] and [[Windows]] support module SQL for C/C++, and Mimer SQL for [[OpenVMS]] also supports module SQL for COBOL, Fortran and Pascal.<ref>{{cite web
	~~\|url=https://docs.mimer.com/MimerSqlManual/latest/Manuals/Module_SQL/Module_SQL.htm~~
	~~\|title=Module SQL\|publisher=[[Mimer SQL]]~~
	~~\|work=Mimer SQL Programmer's Manual latest version, Module SQL}}</ref>~~

	~~=== [[Oracle Database]] ===~~
	~~Oracle 8.0 supported SQL*Module for Ada but support has been removed in later versions.<ref>{{cite web~~
	~~\|url=https://docs.oracle.com/cd/A87860_01/doc/appdev.817/a58231.pdf~~
	~~\|title=SQL*Module™ for Ada - Programmer's Guide~~
	~~\|work=SQL*Module™ for Ada - Programmer's Guide~~
	~~\|publisher=Oracle Corporation~~
	~~\|accessdate=2023-06-19~~
	~~}}</ref> SQL*Module is a module language that supports the Ada83 language standard for Ada.<ref>{{cite web~~
	~~\|url=http://download.oracle.com/docs/cd/B10501_01/server.920/a96530/migcompa.htm#1010868~~
	~~\|title=Ada Support in Version 8~~
	~~\|work=Oracle9i Database Migration, Release 2 (9.2), Chapter 5. Compatibility and Interoperability~~
	~~\|publisher=Oracle Corporation~~
	~~\|accessdate=2023-03-30~~
	~~}}</ref>~~

	~~=== [[Oracle_Rdb\|Oracle Rdb]] ===~~
	~~Supported host languages are Ada, [[BASIC]], C, COBOL, Fortran, Pascal and PL/I.<ref>{{cite web~~
	~~\|url=https://download.oracle.com/otn_hosted_doc/rdb/pdf/gsp.pdf~~
	~~\|title=Oracle Rdb7™, Guide to SQL Programming~~
	~~\|publisher=Oracle Corporation~~
	~~\|accessdate=2023-06-05~~
	~~}}</ref>~~

	~~== References ==~~
	~~<references/>~~

	~~== External links ==~~
	* [https://docs.oracle.com/cd/B10501_01/appdev.920/a58231/ch2.htm SQL*Module for Ada Programmer's Guide, Release 8.0]
	* [https://developer.mimer.com/article/module-sql/ Module SQL, Mimer SQL Developer]

	~~[[Category:SQL]]~~
	~~[[Category:Declarative programming languages]]~~
	~~[[Category:Query languages]]~~
	~~[[Category:Data modeling languages]]~~
	~~[[Category:Database APIs]]~~
	~~[[Category:SQL data access]]~~
	~~{{⚠️🚨COPIED from EverybodyWiki ❗❕⚠️😡😤Please respect Licence CC-BY-SA ❗}}~~
	~~{{Source~~ Wikipedia}}

WikiMasterBot2: Moved page from wikipedia:en:Draft:Module SQL (history)

2023-08-19T13:21:52Z

Moved page from wikipedia:en:Draft:Module SQL ([[Edithistory:|history]])

← Older revision		Revision as of 13:21, 19 August 2023
Line 1:		Line 1:
			{{Short description\|Computer programming method}}
			{{Draft topics\|software\|computing\|technology}}
			{{AfC topic\|stem}}
			{{AfC submission\|\|\|ts=20230607143145\|u=Fjerdingen\|ns=118}}
	{{AFC comment\|1=In-depth coverage in independent secondary sources are required. [[User:Stuartyeates\|Stuartyeates]] ([[User talk:Stuartyeates\|talk]]) 19:21, 10 May 2023 (UTC)}}		{{AFC comment\|1=In-depth coverage in independent secondary sources are required. [[User:Stuartyeates\|Stuartyeates]] ([[User talk:Stuartyeates\|talk]]) 19:21, 10 May 2023 (UTC)}}

	----		----

	~~{{Short description\|Computer programming method}}~~
	~~{{Draft topics\|software\|computing\|technology}}~~
	~~{{AfC topic\|stem}}~~

	'''Module SQL''' is a method of combining the [[computing]] power of a [[programming language]] and the [[database]] [[Data Manipulation Language\|manipulation]] capabilities of [[SQL]]. Module SQL [[statement (programming)\|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 [[compiler\|compiled]] into calls to a SQL runtime library that interacts with the [[DBMS\|Database management system]]. This allows programmers to call SQL statements from ~~programs~~ written in ~~any number of~~ languages ~~such as [[:Category:C programming language family\|C/C++]], [[Ada (programming language)\|Ada]], [[COBOL]] and [[Fortran]]. Module SQL is closely related to [[Embedded SQL]]~~.
			'''Module SQL''' is a method of combining the [[computing]] power of a [[programming language]] and the [[database]] [[Data Manipulation Language\|manipulation]] capabilities of [[SQL]]. Module SQL [[statement (programming)\|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 [[compiler\|compiled]] into calls to a SQL runtime library that interacts with the [[DBMS\|Database management system]]. This allows programmers to call SQL statements from applications written in regular programming languages.

	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.<ref name="modulelang">		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.<ref name="modulelang">
Line 15:		Line 17:
	\|work=SQLModule for Ada Programmer's Guide, Release 8.0, Chapter 1. Introduction to SQLModule		\|work=SQLModule for Ada Programmer's Guide, Release 8.0, Chapter 1. Introduction to SQLModule
	\|publisher=[[Oracle Corporation]]		\|publisher=[[Oracle Corporation]]
	\|accessdate=2023-03-30}}		\|accessdate=2023-03-30}}</ref>
	</ref> ~~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~~.<ref>{{cite web		Module SQL is closely related to [[Embedded SQL]]. "SQL client modules are self-contained collections of SQL statements. Unlike embedded SQL, in which the SQL statements are inserted into the host programming language, SQL client modules are separate from the host language. The host language contains calls that invoke the module, which in turn executes the SQL statements within that module."<ref>{{cite book \|last1=Oppel \|first1=Andrew \|title=SQL: A Beginner's Guide, Fourth Edition, 4th Edition \|date=November 2015 \|publisher=McGraw-Hill \|isbn=978-0071842594 \|pages=544 \|edition=4th \|url=https://learning.oreilly.com/library/view/sql-a-beginners/9780071842570/ch18.html#:-:text=Create%20SQL%20Client%20Modules}}</ref>
	\|url=https://www.iso.org/standard/~~63556~~.html
	\|title=SQL Standard ~~2016~~ Chapter 13 SQL-client modules		===SQL Standard Compliance===
	\|work=ISO/IEC 9075-2:~~2016~~ Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
			The [[SQL:2023]] standard (ISO/IEC 9075-2:2023 Information technology — Database languages SQL — Part 2: Foundation (SQL/Foundation), chapter 13<ref>{{cite web
			\|url=https://www.iso.org/standard/76584.html
			\|title=SQL Standard 2023, Chapter 13 SQL-client modules
			\|work=ISO/IEC 9075-2:2023 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
	\|publisher=[[ISO]]		\|publisher=[[ISO]]
	\|accessdate=2023-03-30		\|accessdate=2023-06-05
	}}</ref>		}}</ref>) 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''. Specified host languages are:

	~~== Database systems that support module SQL ==~~		* [[Ada_(programming_language)\|Ada]] - Feature B111, “Module language Ada”
			* [[C_(programming_language)\|C]] - Feature B112, “Module language C”
			* [[COBOL]] - Feature B113, “Module language COBOL”
			* [[Fortran]] - Feature B114, “Module language Fortran”
			* [[MUMPS]] - Feature B115, “Module language MUMPS”
			* [[Pascal_(programming_language)\|Pascal]] - Feature B116, “Module language Pascal”
			* [[PL/I]] - Feature B117, “Module language PL/I”

	~~=== [[Microsoft SQL Server]] ===~~		(All the languages listed above are optional features, which means that each vendor can decide which language(s) to support.)
	~~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~~
	~~\|title=SQL Modules~~
	~~\|publisher=[[Microsoft]]~~
	~~\|accessdate=2023-03-30~~
	~~}}</ref>~~

			== Database systems that support module SQL ==
	=== [[Mimer SQL]] ===		=== [[Mimer SQL]] ===
	Mimer SQL for [[Linux]], [[macOS]], [[OpenVMS]] and [[Windows]] support module SQL.<ref>{{cite web		Mimer SQL 11.0 and later for [[Linux]], [[macOS]], [[OpenVMS]] and [[Windows]] support module SQL for C/C++, and Mimer SQL for [[OpenVMS]] also supports module SQL for COBOL, Fortran and Pascal.<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 (programming language)\|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 (programming language)\|Pascal]]~~
	~~: Module SQL for Pascal is supported on OpenVMS.~~

	=== [[Oracle Database]] ===		=== [[Oracle Database]] ===
	~~; [[~~Ada ~~(programming language)~~\|Ada]]		Oracle 8.0 supported SQL*Module for Ada but support has been removed in later versions.<ref>{{cite web
	~~: Starting with Oracle8,~~ SQL*Module ~~uses~~ Ada ~~but appears to have not been updated since~~.<ref>{{cite web		\|url=https://docs.oracle.com/cd/A87860_01/doc/appdev.817/a58231.pdf
			\|title=SQL*Module™ for Ada - Programmer's Guide
			\|work=SQL*Module™ for Ada - Programmer's Guide
			\|publisher=Oracle Corporation
			\|accessdate=2023-06-19
			}}</ref> SQL*Module is a module language that supports the Ada83 language standard for Ada.<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
	\|title=Ada Support in Version 8		\|title=Ada Support in Version 8
Line 58:		Line 61:
	\|publisher=Oracle Corporation		\|publisher=Oracle Corporation
	\|accessdate=2023-03-30		\|accessdate=2023-03-30
	}}</ref> ~~SQL*Module is a module language that supports the Ada83 language standard for~~ Ada.		}}</ref>

			=== [[Oracle_Rdb\|Oracle Rdb]] ===
			Supported host languages are Ada, [[BASIC]], C, COBOL, Fortran, Pascal and PL/I.<ref>{{cite web
			\|url=https://download.oracle.com/otn_hosted_doc/rdb/pdf/gsp.pdf
			\|title=Oracle Rdb7™, Guide to SQL Programming
			\|publisher=Oracle Corporation
			\|accessdate=2023-06-05
			}}</ref>

	== References ==		== References ==

WikiMasterBot2: Moved page from wikipedia:en:Draft:Module SQL (history)

2023-06-05T13:52:23Z

Moved page from wikipedia:en:Draft:Module SQL ([[Edithistory:|history]])

← Older revision		Revision as of 13:52, 5 June 2023
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		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

WikiMasterBot2: Moved page from wikipedia:en:Draft:Module SQL (history)

2023-05-15T13:33:13Z

Moved page from wikipedia:en:Draft:Module SQL ([[Edithistory:|history]])

New page

{{AFC comment|1=In-depth coverage in independent secondary sources are required. [[User:Stuartyeates|Stuartyeates]] ([[User talk:Stuartyeates|talk]]) 19:21, 10 May 2023 (UTC)}}

----

{{Short description|Computer programming method}}
{{Draft topics|software|computing|technology}}
{{AfC topic|stem}}

'''Module SQL''' is a method of combining the [[computing]] power of a [[programming language]] and the [[database]] [[Data Manipulation Language|manipulation]] capabilities of [[SQL]]. Module SQL [[statement (programming)|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 [[compiler|compiled]] into calls to a SQL runtime library that interacts with the [[DBMS|Database management system]]. This allows programmers to call SQL statements from programs written in any number of languages such as [[:Category:C programming language family|C/C++]], [[Ada (programming language)|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.<ref name="modulelang">
{{cite web
|url=http://download.oracle.com/docs/cd/B10501_01/appdev.920/a58231/ch1.htm#2889
|title=The Module Language Concept
|work=SQL*Module for Ada Programmer's Guide, Release 8.0, Chapter 1. Introduction to SQL*Module
|publisher=[[Oracle Corporation]]
|accessdate=2023-03-30}}
</ref> 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.<ref>{{cite web
|url=https://www.iso.org/standard/63556.html
|title=SQL Standard 2016 Chapter 13 SQL-client modules
|work=ISO/IEC 9075-2:2016 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
|publisher=[[ISO]]
|accessdate=2023-03-30
}}</ref>

== Database systems that support module SQL ==

=== Microsoft SQL Server ===
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
|title=SQL Modules
|publisher=[[Microsoft]]
|accessdate=2023-03-30
}}</ref>

=== 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
|title=Module SQL|publisher=[[Mimer SQL]]
|work=Mimer SQL Programmer's Manual latest version, Module SQL}}</ref>
; 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.<ref>{{cite web
|url=http://download.oracle.com/docs/cd/B10501_01/server.920/a96530/migcompa.htm#1010868
|title=Ada Support in Version 8
|work=Oracle9i Database Migration, Release 2 (9.2), Chapter 5. Compatibility and Interoperability
|publisher=Oracle Corporation
|accessdate=2023-03-30
}}</ref> SQL*Module is a module language that supports the Ada83 language standard for Ada.

== References ==
<references/>

== External links ==
* [https://docs.oracle.com/cd/B10501_01/appdev.920/a58231/ch2.htm SQL*Module for Ada Programmer's Guide, Release 8.0]
* [https://developer.mimer.com/article/module-sql/ Module SQL, Mimer SQL Developer]

[[Category:SQL]]
[[Category:Declarative programming languages]]
[[Category:Query languages]]
[[Category:Data modeling languages]]
[[Category:Database APIs]]
[[Category:SQL data access]]
{{⚠️🚨COPIED from EverybodyWiki ❗❕⚠️😡😤Please respect Licence CC-BY-SA ❗}}
{{Source Wikipedia}}