Content deleted Content added
No edit summary |
FredrikSande (talk | contribs) mNo edit summary |
||
Line 6:
'''SQL PL''' stands for [[SQL|Structured Query Language]] Procedural Language and was developed by IBM as a set of commands that extend the use of SQL in the [[IBM DB2]] (DB2 UDB Version 7) database system.<ref>[http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.sql.doc/doc/c0011916.htm IBM Info Center]</ref> It provides [[procedural programming|procedural programmability]] in addition to the querying commands of SQL. It is a subset of the SQL Persistent Stored Modules ([[SQL/PSM]]) language standard.
===== IBM DB2 =====
As of DB2 version 9, SQL PL [[stored procedure]]s can run natively inside the DB2 process (inside the DBM1 address space, more precisely) instead of being fenced in an external process.<ref name="Mullins2012">{{cite book|author=Craig S. Mullins|title=DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS|year=2012|publisher=IBM Press|isbn=978-0-13-283644-9|edition=6th|page=658}}</ref> In DB2 version 9.7 IBM also added a [[PL/SQL]] front-end to this infrastructure (called "SQL Unified Runtime Engine"), meaning that procedural SQL using either the ISO standard or Oracle's syntax compile to [[bytecode]] running on the same engine in DB2.<ref>{{cite web|author=Serge Rielau |url=http://www.ibm.com/developerworks/data/library/techarticle/dm-0907oracleappsondb2/index.html |title=DB2 10: Run Oracle applications on DB2 10 for Linux, UNIX, and Windows |publisher=Ibm.com |date= |accessdate=2012-07-26}}</ref>
===== Raima RDM 14.0 =====
The RDM SQL Programming Language (SQL PL) is based on the ANSI/ISO SQL Persistent Stored Modules (PSM) specification (ISO/IEC 90756-4:2008). It provides a high-level language in which stored procedures and functions can be easily written, compiled and called within the RDM SQL system. In earlier versions of RDM SQL, except for a rudimentary stored procedure capability, all such programming needed to be done through a standard programming language API such as either the native RDM SQL API or ODBC for C/C++ or JDBC for Java programs.<ref>{{Cite web|url=http://docs.raima.com/rdme/14_0/#SQLPL/SQLPL-Intro.htm|title=Raima Technical Whitepaper (RDM 14.0)|last=|first=|date=|website=|publisher=|access-date=}}</ref>
==References==
|