ISO/IEC 9075-4:2016

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

standard by International Organization for Standardization/International Electrotechnical Commission, 12/15/2016

More details

Download

PDF AVAILABLE FORMATS IMMEDIATE DOWNLOAD
$97.44 tax incl.

$232.00 tax incl.

(price reduced by 58 %)

1000 items in stock

Full Description

ISO/IEC 9075-4:2016 species 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 specication of statements to direct the ow of control.

- The assignment of the result of expressions to variables and parameters.

- The specication of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution.

- The specication of statements to signal and resignal conditions.

- The declaration of standing SQL-server cursors.

- The declaration of local variables.

It also includes the denition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.