SQL PL: Difference between revisions

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Revision as of 08:02, 25 November 2012 edit Tijfo098 (talk \| contribs) 16,966 edits native in v9 ← Previous edit		Latest revision as of 00:04, 1 January 2024 edit undo A. B. (talk \| contribs) Extended confirmed users, Page movers, IP block exemptions, New page reviewers, Pending changes reviewers, Rollbackers 54,729 edits Undid "merge" by बिनोद थारू (talk). No content from this page was ever added to the supposed target page. Back door deletion? Tags: Removed redirect Undo
(25 intermediate revisions by 14 users not shown)
Line 1: {{Primary sources~~\|date=November 2009}}{{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.▼ ▲'''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]] (DB2 UDB Version 7) database system.<ref>[~~http~~https://~~publib.boulder~~www.ibm.com/~~infocenter~~support/~~db2luw~~knowledgecenter/v9en/~~index~~SSEPGG_11.1.~~jsp?topic=~~0/com.ibm.db2.~~udb~~luw.apdv.~~sql~~sqlpl.doc/doc/c0011916.~~htm~~html IBM ~~Info~~Knowledge 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>▼ ▲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/>~~ == External links == * [http://www.rosettacode.org/wiki/Category:SQL_PL Examples in Rosetta Code] *[http://www.sqlpl-guide.com SQL PL Guide for developing Stored Procedures in DB2] {{DEFAULTSORT:Sql Pl}} {{IBM Db2 product family}} [[Category:SQL]] [[Category:IBM software]] [[Category:IBM DB2]]