Module SQL

Module SQL is a method of combining the <a href="/facts/Computing/Kghtm9fX">computing</a> power of a <a href="/facts/Programming_language/cWTYbgWa">programming language</a> and the <a href="/facts/Database/VYcpkevb">database</a> <a href="/facts/Data_Manipulation_Language/eeJRDUEl">manipulation</a> capabilities of <a href="/facts/SQL/UjQLJcYm">SQL</a>. Module SQL <a href="/facts/Statement_(programming)/bEkBufqX">statements</a> are SQL statements written in an SQL client module, that can be called as routines from the host language program <a href="/facts/Source_code/o9J6Jv23">source code</a> like a host language routine. An SQL standard Module Language file is <a href="/facts/Compiler/WNfCDFJe">compiled</a> into calls to a SQL <a href="/facts/Runtime_library/TJjgyw3t">runtime library</a> that interacts with the <a href="/facts/DBMS/VYcpkevb">Database management system</a>. 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.
Module SQL is closely related to <a href="/facts/Embedded_SQL/IVcX74w3">Embedded SQL</a>. "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."

Module SQL open-in-new

Module SQL