CAN/CSA-ISO/IEC 9075-14:18 (R2022)

Foreword
Introduction
1 Scope
2 Normative references
3 Definitions, notations and conventions
4 Concepts
5 Lexical elements
6 Scalar expressions
7 Query expressions
8 Predicates
9 Mappings
10 Additional common rules
11 Additional common elements
12 Schema definition and manipulation
13 SQL-client modules
14 Data manipulation
15 Control statements
16 Session management
17 Dynamic SQL
18 Embedded SQL
19 Call-Level Interface specifications
20 Diagnostics management
21 Information Schema
22 Definition Schema

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-14\" throughout. This Standard supersedes CAN/CSA-ISO/IEC 9075-14:13 (adopted ISO/IEC 9075-14:2011). Scope This part of ISO/IEC 9075 defines ways in which Database Language SQL can be used in conjunction with XML.

CSA 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-14” throughout. This Standard supersedes CAN/CSA-ISO/IEC 9075-14:13 (adopted ISO/IEC 9075-14:2011). At the time of publication, ISO/IEC 9075-14:2016 is available from ISO and IEC in English only. CSA Group will publish the French version when it becomes available from ISO and IEC. This Standard was reviewed by the CSA TCIT under the jurisdiction of the CSA Strategic Steering Committee on Information and Communications Technology and deemed acceptable for use in Canada. From time to time, ISO/IEC may publish addenda, corrigenda, etc. The TCIT will review these documents for approval and publication. For a listing, refer to the Current Standards Activities page at standardsactivities.csa.ca. This Standard has been formally approved, without modification, by the Technical Committee and has been developed in compliance with Standards Council of Canada requirements for National Standards of Canada. It has been published as a National Standard of Canada by CSA Group. Scope This part of ISO/IEC 9075 defines ways in which Database Language SQL can be used in conjunction with XML.