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.

ANSI - INCITS/ISO/IEC 9075-4

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

active, Most Current
Organization: ANSI
Publication Date: 1 January 2016
Status: active
Page Count: 203
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

INCITS/ISO/IEC 9075-4
January 1, 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....
INCITS/ISO/IEC 9075-4
January 1, 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....
INCITS/ISO/IEC 9075-4
December 18, 2008
Information technology — Database languages — SQL — Part 4: Persistent Stored Modules (SQL/PSM)
A description is not available for this item.
INCITS/ISO/IEC 9075-4
December 15, 2003
Information technology Database languages SQL Part 4: Persistent Stored Modules (SQL/PSM)
A description is not available for this item.
INCITS/ISO/IEC 9075-4
December 8, 1999
Information Technology – Database Language SQL – Part 4: Persistent Stored Modules (SQL/PSM)
A description is not available for this item.
INCITS/ISO/IEC 9075-4
December 8, 1999
Information Technology – Database Language 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-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-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-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