Revision as of 15:32, 15 March 2016 edit Dodi 8238 (talk \| contribs) Extended confirmed users 8,228 edits as I suspected, the Similar languages section was just copied from the PL/SQL article (it's better to just link to it in the See also section); addition of Raima RDM seems to be WP:PROMO ← Previous edit		Revision as of 15:34, 15 March 2016 edit undo Dodi 8238 (talk \| contribs) Extended confirmed users 8,228 edits bit about PL/SQL does not appear to belong in this article, but in the one about PL/SQL (also, see WP:NOTGUIDE) Next edit →
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>[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. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.{{cn}} 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>

SQL PL: Difference between revisions