ISO/IEC 9075-4:2016

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

ISO/IEC 9075-4:2016 speci?es 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 speci?cation of statements to direct the ?ow of control.

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

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

– The speci?cation of statements to signal and resignal conditions.

– The declaration of standing SQL-server cursors.

– The declaration of local variables.

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

Edition	2016
Standard Part No	4
Published Date	2016
Published By	International Standardization Organisation /International Electrotechnical Commission
Page Count	188