User Tools

Site Tools


Sidebar

Welcome to DIDO WIKI

dido:public:ra:xapend:xapend.b_stds:tech:iso:dblang_sql_part4

ISO/IEC 9075-04:2016 Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)

return to the ISO Standards

Table 1: Data sheet for Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)
Title Database languages — SQL — Part 4: Persistent stored modules
Acronym SQL/PSM
Version 2016
Document Number 9075-4:2016
Release Date 2016-12
Reference https://www.iso.org/obp/ui/#iso:std:iso-iec:9075:-4:ed-6:v1:en
Note: The following is an excerpt from the official ISO catalog. It is provided here as a convenience and is not authoritative. Refer to the original document as the authoritative reference.

Scope

This part of International Standard ISO/IEC 9075 specifies the syntax and semantics of a database language for declaring and maintaining persistent database language routines in SQL-server modules.

The database language for <externally-invoked procedure>s and <SQL-invoked routine>s includes:

  • The specification of statements to direct the flow of control.
  • The assignment of the result of expressions to variables and parameters.
  • The specification of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution.
  • The specification of statements to signal and resignal conditions.
  • The declaration of standing SQL-server cursors.
  • The declaration of local variables.

It also includes the definition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.

See Also

dido/public/ra/xapend/xapend.b_stds/tech/iso/dblang_sql_part4.txt · Last modified: 2021/08/17 15:22 by murphy
Translations of this page: