Skip to main content

ISO/IEC 9075-4:2016

Current Date published:

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

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.

Get this standard Prices exclude GST
PDF ( Single user document)
$311.47 NZD
HardCopy
$311.47 NZD
Networkable PDF
Price varies
Preview only close
Prev {{ page }}/ {{ numPages }} Next
Preview only close
Prev {{ page }}/ {{ numPages }} Next

Keep me up-to-date

Sign up to receive updates when there are changes to this standard

Related Information

Similar Standards

  • AS/NZS 1486:1993

    Information technology - Programming languages - Fortran 90

  • AS/NZS 3968.0:1994

    Information technology - Database languages - SQL - Definition of data structures and basic operations

  • AS/NZS 3968.0:1994 A1

    Information technology - Database languages - SQL - Definition of data structures and basic operations: Amendment 1

  • AS/NZS 3968.3:1998

    Information technology - Database languages - SQL - Call-level interface

Preview only close
Prev {{ page }}/ {{ numPages }} Next
Preview only close
Prev {{ page }}/ {{ numPages }} Next

ISO/IEC 9075-4:2016

Get this standard Prices exclude GST
PDF ( Single user document)
$311.47 NZD
HardCopy
$311.47 NZD
Networkable PDF
Price varies

Request to add this standard to your subscription

ISO/IEC 9075-4:2016

Price varies
Online library subscription

Click "Send request for subscription" to request for your Account Administrator to add this standard to your subscripiton.

Comment

Cancel