ISO/IEC 9075-4:2016

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

Publication date:   Dec 14, 2016

95.99 Withdrawal of Standard   Jun 1, 2023

General information

95.99 Withdrawal of Standard   Jun 1, 2023

ISO/IEC

ISO/IEC JTC 1/SC 32 Data management and interchange

International Standard

35.060   Languages used in information technology

Buying

  Withdrawn

PDF - €76.23

  English  



Buy

Scope

ISO/IEC 9075-4:2016 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.

Life cycle

NOW

WITHDRAWN
ISO/IEC 9075-4:2016
95.99 Withdrawal of Standard
Jun 1, 2023

CORRIGENDA / AMENDMENTS

WITHDRAWN
ISO/IEC 9075-4:2016/Cor 1:2019

WITHDRAWN
ISO/IEC 9075-4:2016/Cor 2:2022

REVISED BY

PUBLISHED
ISO/IEC 9075-4:2023