SQL PL: Difference between revisions

Revision as of 15:50, 19 July 2007

Latest revision as of 00:04, 1 January 2024

(38 intermediate revisions by 24 users not shown)

Line 1:

{{Primary sources|date=November 2009}}

{{stub}}

'''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 [[DB2IBM Db2]] [[(DB2 UDB]] Version 7) database system.<ref>[httphttps://publib.boulderwww.ibm.com/infocentersupport/db2luwknowledgecenter/v9en/indexSSEPGG_11.jsp?topic=1.0/com.ibm.db2.udbluw.apdv.sqlsqlpl.doc/doc/c0011916.htmhtml IBM InfoKnowledge 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>

==See also==

* [[IBM Db2]]

* [[Comparison of relational database management systems]]

==References==

{{reflist}}

<references/>

{{Uncategorized|date=July 2007}}

== External links ==

{{Uncategorizedstub|date=July 2007}}

* [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]]

{{Prog-lang-stub}}