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.

NEN-ISO/IEC 9075-4

Information technology - Database languages SQL - Part 4: Persistent stored modules

active, Most Current
Organization: NEN
Publication Date: 1 June 2023
Status: active
Page Count: 176
ICS Code (Languages used in information technology): 35.060
scope:

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 includes the following capabilities.

- 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

NEN-ISO/IEC 9075-4
June 1, 2023
Information technology - Database languages SQL - Part 4: Persistent stored modules
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...
NEN-ISO/IEC 9075-4/C1
September 1, 2019
Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM)
A description is not available for this item.
NEN-ISO/IEC 9075-4
December 1, 2016
Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM)
NEN-ISO/IEC 9075-4 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...
NEN-ISO/IEC 9075-4/C2
October 1, 2015
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
A description is not available for this item.
NEN-ISO/IEC 9075-4/C1
December 1, 2013
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
A description is not available for this item.
NEN-ISO/IEC 9075-4
January 1, 2012
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....
NEN-ISO/IEC 9075-4/C1
June 1, 2010
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
A description is not available for this item.
NEN-ISO/IEC 9075-4
August 1, 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....
NEN-ISO/IEC 9075-4/C2
April 1, 2007
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
A description is not available for this item.
NEN-ISO/IEC 9075-4/C1
December 1, 2005
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
A description is not available for this item.
NEN-ISO/IEC 9075-4
January 1, 2004
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....
NEN-ISO/IEC 9075-4/C2
July 1, 2003
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
A description is not available for this item.
NEN-ISO/IEC 9075-4
June 1, 2000
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
A description is not available for this item.
View Less
View All

References

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 references:
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 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...
Advertisement