SQL PL: Difference between revisions
m Restauration de la révision ID 1961413 (plus long contenu) |
m remove duplicates internal links |
||
| Line 13: | Line 13: | ||
==See also== | ==See also== | ||
* | * IBM DB2 | ||
* [[Comparison of relational database management systems]] | * [[Comparison of relational database management systems]] | ||
Latest revision as of 20:24, 28 August 2026
SQL PL stands for 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.[1] It provides 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 procedures can run natively inside the DB2 process (inside the DBM1 address space, more precisely) instead of being fenced in an external process.[2] 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.[3]
See also
References
- ↑ IBM Knowledge Center
- ↑ Craig S. Mullins (2012). DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS (6th ed.). IBM Press. p. 658. ISBN 978-0-13-283644-9. Search this book on
- ↑ Serge Rielau. "DB2 10: Run Oracle applications on DB2 10 for Linux, UNIX, and Windows". Ibm.com. Retrieved 2012-07-26.
External links
 | This programming-language-related article is a stub. You can help EverybodyWiki by expanding it. |
This article "SQL PL" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:SQL PL. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.
|
This page exists already on Wikipedia. |
