Hello. Sign In
Standards Store
Look Inside

ISO/IEC 9075-4

6th Edition, December 15, 2016

Complete Document

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

View Abstract
Product Details
Document History

Detail Summary

Active, Most Current

Additional Comments:
Price (USD)
Single User
In Stock
Add to Cart

People Also Bought These:

AWS D17.2/D17.2M
ISO 12233
ISO/IEC 17025
AWS C3.3

Product Details:

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 procedure>s and <SQL-invoked routine>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.
The 9000 Store