CAN/CSA-ISO/IEC 9075-4:18

Foreword
Introduction
1 Scope
2 Normative references
3 Definitions, notations, and conventions
4 Concepts
5 Lexical elements
6 Scalar expressions
7 Query expressions
8 Additional common rules
9 Additional common elements
10 Schema definition and manipulation
11 Access control
12 SQL-client modules
13 Data manipulation
14 Additional data manipulation rules
15 Control statements
16 Dynamic SQL
17 Embedded SQL
18 Diagnostics management
19 Information Schema
20 Definition Schema
21 Status codes
22 Conformance
Annex A (informative) - SQL Conformance Summary
Annex B (informative) - Implementation-defined elements
Annex C (informative) - Implementation-dependent elements
Annex D (informative) - Deprecated features
Annex E (informative) - Incompatibilities with ISO/IEC 9075:2011
Annex F (informative) - SQL feature taxonomy
Annex G (informative) - Defect reports not addressed in
        this edition of this part of ISO/IEC 9075
Index

Preface Standards development within the Information Technology sector is harmonized with international standards development. Through the CSA Technical Committee on Information Technology (TCIT), Canadians serve as the SCC Mirror Committee (SMC) on ISO/IEC Joint Technical Committee 1 on Information Technology (ISO/IEC JTC1) for the Standards Council of Canada (SCC), the ISO member body for Canada and sponsor of the Canadian National Committee of the IEC. Also, as a member of the International Telecommunication Union (ITU), Canada participates in the International Telegraph and Telephone Consultative Committee (ITU-T). For brevity, this Standard will be referred to as \"CAN/CSA-ISO/IEC 9075-4\" throughout. This Standard supersedes CAN/CSA-ISO/IEC 9075-4:13 (adopted ISO/IEC 9075-4:2011). 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.

Preface Standards development within the Information Technology sector is harmonized with international standards development. Through the CSA Technical Committee on Information Technology (TCIT), Canadians serve as the SCC Mirror Committee (SMC) on ISO/IEC Joint Technical Committee 1 on Information Technology (ISO/IEC JTC1) for the Standards Council of Canada (SCC), the ISO member body for Canada and sponsor of the Canadian National Committee of the IEC. Also, as a member of the International Telecommunication Union (ITU), Canada participates in the International Telegraph and Telephone Consultative Committee (ITU-T). For brevity, this Standard will be referred to as \"CAN/CSA-ISO/IEC 9075-4\" throughout. This Standard supersedes CAN/CSA-ISO/IEC 9075-4:13 (adopted ISO/IEC 9075-4:2011). 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.