درباره ما
ANSI INCITS/ISO/IEC 9075-4
Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)
Organization:
ANSI - American National Standards Institute
Year: 2012
Abstract: 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 <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.
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.
Collections
:
-
Statistics
ANSI INCITS/ISO/IEC 9075-4
Show full item record
| contributor author | ANSI - American National Standards Institute | |
| date accessioned | 2017-09-04T15:33:26Z | |
| date available | 2017-09-04T15:33:26Z | |
| date copyright | 2011.01.01 (R 2012) | |
| date issued | 2012 | |
| identifier other | OJOCHFAAAAAAAAAA.pdf | |
| identifier uri | https://yse.yabesh.ir/std/handle/yse/35070 | |
| description abstract | 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 <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. | |
| language | English | |
| title | ANSI INCITS/ISO/IEC 9075-4 | num |
| title | Information technology - Database languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM) | en |
| type | standard | |
| page | 200 | |
| status | Active | |
| tree | ANSI - American National Standards Institute:;2012 | |
| contenttype | fulltext |