Content deleted Content added
m cat |
Undid "merge" by बिनोद थारू (talk). No content from this page was ever added to the supposed target page. Back door deletion? |
||
| (35 intermediate revisions by 21 users not shown) | |||
Line 1:
{{Primary sources|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 [[DB2]] [[UDB]] 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.▼
▲'''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 [[
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>
==See also==
* [[IBM Db2]]
* [[Comparison of relational database management systems]]
==References==
{{reflist}}
== External links ==
* [http://www.rosettacode.org/wiki/Category:SQL_PL Examples in Rosetta Code]
{{DEFAULTSORT:Sql Pl}}
{{IBM Db2 product family}}
[[Category:SQL]]
[[Category:IBM software]]
[[Category:IBM DB2]]
{{
| |||