+91 80984 42953 hello@sascert.in
Verify a certificate ISO standards library Download brochure
ISO/IEC 9075-4:2016Withdrawn

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

Technologies de l'information — Langages de base de données — SQL — Partie 4: Modules stockés persistants (SQL/PSM)

This edition has been replaced by ISO/IEC 9075-4:2023.

Abstract / 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

Amendments & corrigenda

ISO/IEC 9075-4:2016/Cor 1:2019WithdrawnInformation technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM) — Technical Corrigendum 1International Standard · Published 13 Aug 2019 · ISO/IEC JTC 1/SC 32ISO/IEC 9075-4:2016/Cor 2:2022WithdrawnInformation technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM) — Technical Corrigendum 2International Standard · Published 24 Jun 2022 · ISO/IEC JTC 1/SC 32

Replaces

ISO/IEC 9075-4:2011WithdrawnInformation technology — Database languages — SQL — Part 4: Persistent Stored Modules (SQL/PSM)International Standard · Published 15 Dec 2011 · ISO/IEC JTC 1/SC 32ISO/IEC 9075-4:2011/Cor 1:2013WithdrawnInformation technology — Database languages — SQL — Part 4: Persistent Stored Modules (SQL/PSM) — Technical Corrigendum 1International Standard · Published 12 Dec 2013 · ISO/IEC JTC 1/SC 32ISO/IEC 9075-4:2011/Cor 2:2015WithdrawnInformation technology — Database languages — SQL — Part 4: Persistent Stored Modules (SQL/PSM) — Technical Corrigendum 2International Standard · Published 15 Sep 2015 · ISO/IEC JTC 1/SC 32

Replaced by

ISO/IEC 9075-4:2023PublishedInformation technology — Database languages SQL — Part 4: Persistent stored modules (SQL/PSM)International Standard · Published 1 Jun 2023 · ISO/IEC JTC 1/SC 32