GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Main page
  • Contents
  • Current events
  • Random article
  • About Wikipedia
  • Contact us
  • Help
  • Learn to edit
  • Community portal
  • Recent changes
  • Upload file
  • Special pages
  • Search
  • Donate

This view

  • Original page
  • New address

GeezerVison is showing en.wikipedia.org — SQL PL - Wikipedia

icon
This article relies excessively on references to primary sources. Please improve this article by adding secondary or tertiary sources.
Find sources: "SQL PL" – news · newspapers · books · scholar · JSTOR
(November 2009) (Learn how and when to remove this message)

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

  • IBM Db2
  • Comparison of relational database management systems

References

  1. ↑ IBM Knowledge Center
  2. ↑ 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.
  3. ↑ Serge Rielau. "DB2 10: Run Oracle applications on DB2 10 for Linux, UNIX, and Windows". Ibm.com. Retrieved 2012-07-26.

External links

  • Examples in Rosetta Code


Stub icon

This programming-language-related article is a stub. You can help Wikipedia by adding missing information.

  • v
  • t
  • e
Retrieved from "https://en.wikipedia.org/w/index.php?title=SQL_PL&oldid=1356786961"
Categories:
  • SQL
  • IBM software
  • IBM Db2
  • Programming language topic stubs
Hidden categories:
  • Articles with short description
  • Short description matches Wikidata
  • Articles lacking reliable references from November 2009
  • All articles lacking reliable references
  • All stub articles
You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.