• CSA ISO/IEC 9075 : 0

    Withdrawn A Withdrawn Standard is one, which is removed from sale, and its unique number can no longer be used. The Standard can be withdrawn and not replaced, or it can be withdrawn and replaced by a Standard with a different number.

    INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL

    Available format(s):  Hardcopy, PDF

    Withdrawn date:  04-11-2003

    Language(s):  English

    Published date: 

    Publisher:  Canadian Standards Association

    Add To Cart

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

    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 Data assignment rules
    10 Additional common elements
    11 Schema definition and manipulation
    12 Module
    13 Data manipulation
    14 Transaction management
    15 Connection management
    16 Session management
    17 Dynamic SQL
    18 Diagnostics management
    19 Embedded SQL
    20 Direct invocation of SQL
    21 Information Schema and Definition Schema
    22 Status codes
    23 Conformance
    Annex A Leveling the SQL Language
    Annex B Implementation-defined elements
    Annex C Implementation-dependent elements
    Annex D Deprecated features
    Annex E Incompatibilities with ISO/IEC 9075:1989
    Annex F Maintenance and interpretation of SQL
    Index
    Tables

    Abstract - (Show below) - (Hide below)

    Defines the data structures and basic operations on SQL- data. Provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data. Specifies the syntax and semantics of a database language: - for specifying and modifying the structure and the integrity constraints of SQL-data, - for declaring and invoking operations of SQL-data and cursors, and - for declaring database language procedures and embedding them into a standard programming language. Also specifies an Information Schema that describes the structure and the integrity constraints of SQL-data. This standard: - provides a vehicle for portability of data definitions and compilation units between SQL-implementations, - provides a vehicle for interconnection of SQL-implementations, - specifies syntax for embedding SQL-statements in a compilation unit that otherwise conforms to the standard for a particular programming language. It defines how an equivalent compilation unit may be derived that conforms to the particular programming language standard. In that equivalent compilation unit, each embedded SQL-statement has been replaced by statements that invoke a database language procedure that contains the SQL-statement, and - specifies syntax for direct invocation of SQL-statements.

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

    Development Note Supersedes CSA Z243.47. (02/2008)
    Document Type Standard
    Publisher Canadian Standards Association
    Status Withdrawn
    Supersedes

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

    ISO/IEC 10646:2014 Information technology Universal Coded Character Set (UCS)
    ISO 7185:1990 Information technology Programming languages Pascal
    ISO/IEC 2022:1994 Information technology Character code structure and extension techniques
    ISO/IEC 8824:1990 Information technology — Open Systems Interconnection — Specification of Abstract Syntax Notation One (ASN.1)
    ISO/IEC 1989:2014 Information technology — Programming languages, their environments and system software interfaces — Programming language COBOL
    ISO 1539:1980 Programming languages FORTRAN
    ISO/IEC 11756:1999 Information technology Programming languages M
    ISO 8601:2004 Data elements and interchange formats Information interchange Representation of dates and times
    ISO/IEC 10206:1991 Information technology Progamming languages Extended Pascal
    ISO/IEC 9579-2:1998 Information technology — Open Systems Interconnection — Remote Database Access — Part 2: SQL Specialization
    ISO/IEC 9899:2011 Information technology Programming languages C
    ISO/IEC 646:1991 Information technology ISO 7-bit coded character set for information interchange
    ISO 6160:1979 Programming languages PL/1
    ISO/IEC 8652:2012 Information technology — Programming languages — Ada
    • 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