SQL PL: Difference between revisions

Revision as of 16:18, 15 March 2016

Revision as of 01:33, 23 April 2018

Line 4:

}}

'''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>[httphttps://publib.boulderwww.ibm.com/infocentersupport/db2luwknowledgecenter/v9en/indexSSEPGG_11.1.jsp?topic=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>