ISO/IEC 9075-4-2023 PDF

ISO/IEC 9075-4-2023 PDF

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

$162.00 $324.00 -50%
Product Code: ISO/IEC 9075-4
Stock In Stock
Edition: 7.
Published: 06/2023
Number of Pages: 172
File Size: 1 file, 1 Byte

Available Options

Product Description

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

Introduction: The organization of this document is as follows: 1) Clause 1, “Scope”, specifies the scope of this document. 2) Clause 2, “Normative references”, identifies additional standards that, through reference in this document, constitute provisions of this document. 3) Clause 3, “Terms and definitions”, defines the terms and definitions used in this document. 4) Clause 4, “Concepts”, presents concepts used in the definition of persistent stored modules. 5) Clause 5, “Lexical elements”, defines a number of lexical elements used in the definition of persistent stored modules. 6) Clause 6, “Scalar expressions”, defines a number of scalar expressions used in the definition of persistent stored modules. 7) Clause 7, “Query expressions”, defines the elements of the language that produce rows and tables of data as used in persistent stored modules. 8) Clause 8, “Additional common rules”, specifies the rules for assignments that retrieve data from or store data into SQL-data, and formation rules for set operations. 9) Clause 9, “Additional common elements”, defines additional common elements used in the definition of persistent stored modules. 10) Clause 10, “Schema definition and manipulation”, defines the schema definition and manipulation statements associated with the definition of persistent stored modules. 11) Clause 11, “Access control”, defines facilities for controlling access to SQL-data. 12) Clause 12, “SQL-client modules”, defines the facilities for using persistent stored modul

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 condi- tions 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 alsoincludesthedefinitionoftheInformationSchematablesthat containschemainformationpertaining to SQL-server modules and SQL-invoked routines. © ISO/IEC 2023 – All rights reserved

Be the first to write a review for this product.

Write a review

Note: HTML is not translated!
Bad           Good
ISO/IEC 9075-4-2023 PDF

ISO/IEC 9075-4-2023 PDF

$162.00 $324.00