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

EN
Additional Comments:
ENGLISH
Format
Details
Price (USD)
PDF
Single User
$232.00
Print
In Stock
$232.00
Add to Cart

People Also Bought These:

AWS D17.2/D17.2M
AWS C3.3
AWS C7.4/C7.4M
AWS C3.8M/C3.8

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