M00000831
New product
ISO/IEC 9075-4 6th Edition, December 15, 2016 Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM)
In stock
Warning: Last items in stock!
Availability date: 07/13/2021
Description / Abstract:
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 procedures and SQL-invoked routines 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.