Codes & Standards - Purchase
CAN/CSA-ISO/IEC 9075-4-04
Information Technology - Database Languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) (Adopted ISO/IEC 9075-4:2003, third edition, 2003-12-15)
SKU: 2417042
Published by CSA Group
Publication Year 2004
230 pages
Withdrawn
Product Details
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 fors and SQL-invoked routine>s includes:
It also includes the definition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.
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
- 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 re-signal conditions.
- The declaration of local 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.