SQL/PSM

From Wikipedia, the free encyclopedia

SQL/PSM stands for Structured Query Language/Persistent Stored Modules, and was developed by the American National Standards Institute (ANSI) as an extension to SQL.[1] It was first adopted in 1996,[2] and it provides procedural programmability in addition to the querying commands of SQL.

The SQL/PSM extension is defined by ISO/IEC 9075-4:2003. SQL/PSM standardizes procedural extensions for SQL, including flow of control, condition handling, statement condition signals and resignals, cursors and local variables, and assignment of expressions to variables and parameters. In addition, SQL/PSM formalizes declaration and maintenance of persistent database language routines (e.g., "stored procedures").

[edit] See also

[edit] References

  1. ^ NIST Article
  2. ^ DBMS Magazine

[edit] External links

 This database-related article is a stub. You can help Wikipedia by expanding it.