UNLIMITED FREE
ACCESS TO THE WORLD'S BEST IDEAS

SUBMIT
Already a GlobalSpec user? Log in.

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Customize Your GlobalSpec Experience

Select Your Free Newsletters

Industry Newsletters

Select Your Free Product Alerts

Finish!
Privacy Policy

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

ISO/IEC 9075-4

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

active, Most Current
Buy Now
Organization: ISO
Publication Date: 15 December 2016
Status: active
Page Count: 201
ICS Code (Languages used in information technology): 35.060
scope:

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 s and 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.

Document History

ISO/IEC 9075-4
June 1, 2023
Information technology — Database languages SQL — Part 4: Persistent stored modules (SQL/PSM)
This document 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 s and s...
ISO/IEC 9075-4 CORR 2
June 1, 2022
Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)
A description is not available for this item.
ISO/IEC 9075-4
August 1, 2019
Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM)
A description is not available for this item.
ISO/IEC 9075-4
December 15, 2016
Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM)
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....
ISO/IEC 9075-4
October 1, 2015
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) TECHNICAL CORRIGENDUM 2
A description is not available for this item.
ISO/IEC 9075-4
December 15, 2013
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) TECHNICAL CORRIGENDUM 1
A description is not available for this item.
ISO/IEC 9075-4
December 15, 2011
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
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....
ISO/IEC 9075-4
June 1, 2010
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) TECHNICAL CORRIGENDUM 1
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....
ISO/IEC 9075-4
July 15, 2008
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
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....
ISO/IEC 9075-4
April 15, 2007
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) TECHNICAL CORRIGENDUM 2
A description is not available for this item.
ISO/IEC 9075-4
November 15, 2005
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQUPSM) TECHNICAL CORRIGENDUM 1
A description is not available for this item.
ISO/IEC 9075-4
December 15, 2003
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQUPSM)
A description is not available for this item.
ISO/IEC 9075-4
June 1, 2003
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) TECHNICAL CORRIGENDUM 2
A description is not available for this item.
ISO/IEC 9075-4 CORR 1
December 15, 2000
Information Technology - Database Languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) TECHNICAL CORRIGENDUM 1
A description is not available for this item.
ISO/IEC 9075-4
December 1, 1999
Information Technology - Database Languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
A description is not available for this item.
ISO/IEC 9075-4
November 15, 1999
Information technology - Database languages - SQL TECHNICAL CORRIGENDUM 1
A description is not available for this item.
View Less
View All

References

This document references:
ISO/IEC 9075-1 - Information technology - Database languages - SQL - Part 1: Framework (SQL/Framework)
Published by ISO on December 15, 2016
This part of ISO/IEC 9075 describes the conceptual framework used in other parts of ISO/IEC 9075 to specify the grammar of SQL and the result of processing statements in that language by an...
This document references:
ISO/IEC 9075-1 - Information technology - Database languages - SQL - Part 1: Framework (SQL/Framework)
Published by ISO on December 15, 2016
This part of ISO/IEC 9075 describes the conceptual framework used in other parts of ISO/IEC 9075 to specify the grammar of SQL and the result of processing statements in that language by an...
This document references:
ISO/IEC 9075-11 - Information technology - Database languages - SQL - Part 11: Information and definition schemas (SQL/Schemata)
Published by ISO on December 15, 2016
This part of ISO/IEC 9075 specifies an Information Schema and a Definition Schema that describes: — The structure and integrity constraints of SQL-data. — The security and authorization...
This document is referenced by:
ISO/IEC 9075-14 - Information technology - Database languages - SQL - Part 14: XML-Related Specifications (SQL/XML)
Published by ISO on December 15, 2016
This part of ISO/IEC 9075 defines ways in which Database Language SQL can be used in conjunction with XML
This document is referenced by:
ISO/IEC 9075-10 - Information technology - Database languages - SQL - Part 10: Object language bindings (SQL/OLB)
Published by ISO on December 15, 2016
ISO/IEC 9075-2 specifies embedded SQL for the programming languages: Ada, C, COBOL, Fortran, MUMPS, Pascal, and PL/I. This part of ISO/IEC 9075 defines similar features of Database language SQL that...
This document is referenced by:
ISO/IEC 9075-2 - Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
Published by ISO on August 1, 2019
A description is not available for this item.
This document is referenced by:
BS ISO/IEC 9075-1 - Information technology - Database languages - SQL Part 1: Framework (SQL/Framework)
Published by BSI on June 30, 2023
A description is not available for this item.
This document is referenced by:
CSA ISO/IEC 9579 - Information technology - Remote database access for SQL with security enhancement
Published by CSA on January 1, 2004
Introduction Remote Database Access for SQL (RDA/SQL) International Standard is a member of a set of International Standards produced to facilitate the interworking of computer systems. This...
This document is referenced by:
ISO/IEC 9075-2 - Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
Published by ISO on August 1, 2019
A description is not available for this item.
View Less
View All
Advertisement