CAN/CSA-ISO/IEC 9075-4-09

Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM)
This National Standard of Canada is equivalent to International Standard ISO/IEC 9075-4:2008. 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 <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.
OEN:
CSA
Langue:
English
Code(s) de l'ICS:
35.060
Statut:
Annulée
Date de Publication:
2009-09-30
Numéro Standard:
CAN/CSA-ISO/IEC 9075-4-09