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

return to the ISO Standards

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