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

Designation Number:
CAN/CSA-ISO/IEC 9075-4:18
Standard Type:
National Standard of Canada - Adoption of International Standard
Standard Development Activity:
Reaffirmation
ICS code(s):
35.060
Status:
Proceeding to development
SDO Comment Period Start Date:
SDO Comment Period End Date:
Posted On:

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 s and 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.

Project need:

To review the Standard within the required 5 year period.

Note: The information provided above was obtained by the Standards Council of Canada (SCC) and is provided as part of a centralized, transparent notification system for new standards development. The system allows SCC-accredited Standards Development Organizations (SDOs), and members of the public, to be informed of new work in Canadian standards development, and allows SCC-accredited SDOs to identify and resolve potential duplication of standards and effort.

Individual SDOs are responsible for the content and accuracy of the information presented here. The text is presented in the language in which it was provided to SCC.