ISO/IEC 9075-4:2016
Superseded
A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.
View Superseded by
Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)
Hardcopy , PDF
English
14-12-2016
01-06-2023
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.
| Committee |
ISO/IEC JTC 1/SC 32
|
| DevelopmentNote |
Supersedes ISO/IEC 9075. (04/2001)
|
| DocumentType |
Standard
|
| Pages |
188
|
| PublisherName |
International Organization for Standardization
|
| Status |
Superseded
|
| SupersededBy | |
| Supersedes |
| Standards | Relationship |
| NEN-ISO/IEC 9075-4:2016 | Identical |
| JIS X 3005-4:2019 | Identical |
| BS ISO/IEC 9075 1-4,9-11,13-14:2010 | Identical |
| BS ISO/IEC 9075-4:1999 | Identical |
| CAN/CSA-ISO/IEC 9075-4:18 (R2022) | Identical |
| BS ISO/IEC 9075 1-4, 9-11, 13-14:2016 | Identical |
| INCITS/ISO/IEC 9075-4 : 2012 | Identical |