Back

ISO/IEC 9075-4:2016

Information technology -- Database languages -- SQL -- Part 4: Persistent stored modules (SQL/PSM)

General information
Withdrawn from 01.06.2023
Directives or regulations
None

Standard history

Status
Date
Type
Name
01.06.2023
Main
24.06.2022
Corrigendum
13.08.2019
Corrigendum
14.12.2016
Main
Main
ISO/IEC 9075-4:2011
Corrigendum
ISO/IEC 9075-4:2011/Cor 1:2013
Corrigendum
ISO/IEC 9075-4:2011/Cor 2:2015
ISO/IEC 9075-4:2016 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 s and 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.
*
*
*
PDF
79.98 € incl tax
Standard monitoring