Content deleted Content added
m Reverted unexplained removal of content (HG) |
m General Fixes using AWB |
||
Line 1:
{{multiple issues|
{{Primary sources
{{Notability|date=November 2009}}
}}
'''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.
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>
==References==
| |||