Language:
    • Available Formats
    • Options
    • Availability
    • Priced From ( in USD )
    • Printed Edition
    • Ships in 1-2 business days
    • $263.00
    • Add to Cart
    • Printed Edition + PDF
    • Immediate download
    • $434.00
    • Add to Cart

Customers Who Bought This Also Bought

 

About This Item

 

Full Description

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.

 

Document History

  1. ISO/IEC 9075-4:2023


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

    • Most Recent
  2. ISO/IEC 9075-4:2016

    👀 currently
    viewing


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

    • Historical Version
  3. ISO/IEC 9075-4:2016/Cor1:2019


    Corrigendum

    • Historical Version
  4. ISO/IEC 9075-4:2016/Cor2:2022


    Corrigendum

    • Historical Version
  5. ISO/IEC 9075-4:2011


    Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)

    • Historical Version
  6. ISO/IEC 9075-4:2008


    Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)

    • Historical Version
  7. ISO/IEC 9075-4:2003


    Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)

    • Historical Version
 

Amendments, rulings, supplements, and errata

  1. ISO/IEC 9075-4:2016/Cor2:2022

    Free
    Download


    Corrigendum

  2. ISO/IEC 9075-4:2016/Cor1:2019

    Free
    Download


    Corrigendum