ISO/IEC 9075-4:2016
Ausgabedatum: 2016 12 14
Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)
ISO/IEC 9075-4:2016 speci¿es 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 speci¿cation of statements to direct the ¿ow of control.
- The assignment of the result of expressions to variables and parameters.
- The speci¿cation of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution.
- The speci¿cation of statements to signal and resignal conditions.
- The declaration of standing SQL-server cursors.
- The declaration of local variables.
It also includes the de¿nition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.