• CAN/CSA-ISO/IEC 9075-1:18

    Current The latest, up-to-date edition.

    Information technology - Database languages - SQL - Part 1: Framework (SQL/Framework) (Adopted ISO/IEC 9075-1:2061, fifth edition, 2016-12-15)

    Available format(s):  Hardcopy, PDF

    Language(s):  English

    Published date:  01-01-2018

    Publisher:  Canadian Standards Association

    Add To Cart

    Table of Contents - (Show below) - (Hide below)

    Foreword
    Introduction
    1 Scope
    2 Normative references
    3 Definitions and use of terms
    4 Concepts
    5 The parts of ISO/IEC 9075
    6 Notation and conventions used in other parts of ISO/IEC 9075
    7 Annexes to the parts of ISO/IEC 9075
    8 Conformance
    Annex A (informative) - Maintenance and interpretation of SQL
    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

    Abstract - (Show below) - (Hide below)

    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-1\" throughout. This Standard supersedes CAN/CSA-ISO/IEC 9075-1:13 (adopted ISO/IEC 9075-1:2011). Scope This part of ISO/IEC 9075 describes the conceptual framework used in other parts of ISO/IEC 9075 to specify the grammar of SQL and the result of processing statements in that language by an SQL-implementation. This part of ISO/IEC 9075 also defines terms and notation used in the other parts of ISO/IEC 9075.

    Scope - (Show below) - (Hide below)

    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-1\" throughout. This Standard supersedes CAN/CSA-ISO/IEC 9075-1:13 (adopted ISO/IEC 9075-1:2011). Scope This part of ISO/IEC 9075 describes the conceptual framework used in other parts of ISO/IEC 9075 to specify the grammar of SQL and the result of processing statements in that language by an SQL-implementation. This part of ISO/IEC 9075 also defines terms and notation used in the other parts of ISO/IEC 9075.

    General Product Information - (Show below) - (Hide below)

    Document Type Standard
    Publisher Canadian Standards Association
    Status Current
    Supersedes

    Standards Referencing This Book - (Show below) - (Hide below)

    ISO/IEC 9075-2:2016 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
    ISO/IEC 10646:2014 Information technology Universal Coded Character Set (UCS)
    ISO/IEC 14651:2016 Information technology International string ordering and comparison Method for comparing character strings and description of the common template tailorable ordering
    ISO/IEC 9075-10:2016 Information technology — Database languages — SQL — Part 10: Object language bindings (SQL/OLB)
    ISO/IEC 9075-9:2016 Information technology — Database languages — SQL — Part 9: Management of External Data (SQL/MED)
    ISO/IEC 9075-13:2016 Information technology — Database languages — SQL — Part 13: SQL Routines and types using the Java TM programming language (SQL/JRT)
    ISO/IEC 9075-3:2016 Information technology — Database languages — SQL — Part 3: Call-Level Interface (SQL/CLI)
    ISO/IEC 9075-14:2016 Information technology — Database languages — SQL — Part 14: XML-Related Specifications (SQL/XML)
    ISO/IEC 9075-11:2016 Information technology — Database languages — SQL — Part 11: Information and definition schemas (SQL/Schemata)
    ISO/IEC 9075-4:2016 Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)
    • Access your standards online with a subscription

      Features

      • Simple online access to standards, technical information and regulations
      • Critical updates of standards and customisable alerts and notifications
      • Multi - user online standards collection: secure, flexibile and cost effective