• ANSI INCITS 135 : 1992

    Superseded A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.

    INFORMATION SYSTEMS - DATABASE LANGUAGE - SQL

    Available format(s):  Hardcopy, PDF

    Superseded date:  23-07-2013

    Language(s):  English

    Published date:  01-01-1998

    Publisher:  Information Technology Industry Council

    Add To Cart

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

    Foreword
    Introduction
    1 Scope
    2 Normative references
    3 Definitions, notations, and conventions
       3.1 Definitions
       3.2 Notation
       3.3 Conventions
       3.4 Object identifier for Database Language SQL
    4 Concepts
       4.1 Data types
       4.2 Character strings
       4.3 Bit strings
       4.4 Numbers
       4.5 Datetimes and intervals
       4.6 Type conversions and mixing of data types
       4.7 Domains
       4.8 Columns
       4.9 Tables
       4.10 Integrity constraints
       4.11 SQL-schemas
       4.12 Catalogs
       4.13 Clusters of catalogs
       4.14 SQL-data
       4.15 SQL-environment
       4.16 Modules
       4.17 Procedures
       4.18 Parameters
       4.19 Diagnostics area
       4.20 Standard programming languages
       4.21 Cursors
       4.22 SQL-statements
       4.23 Embedded syntax
       4.24 SQL dynamic statements
       4.25 Direct invocation of SQL
       4.26 Privileges
       4.27 SQL-agents
       4.28 SQL-transactions
       4.29 SQL-connections
       4.30 SQL-sessions
       4.31 Client-server operation
       4.32 Information Schema
       4.33 Leveling
       4.34 SQL Flagger
    5 Lexical elements
       5.1
       5.2 and
       5.3
       5.4 Names and identifiers
    6 Scalar expressions
       6.1
       6.2 and
       6.3


       6.4
       6.5
       6.6
       6.7
       6.8
       6.9
       6.10
       6.11
       6.12
       6.13
       6.14
       6.15
    7 Query expressions
       7.1
       7.2

       7.3

       7.4
       7.5
       7.6
       7.7
       7.8
       7.9
       7.10
       7.11 , , and

    8 Predicates
       8.1
       8.2
       8.3
       8.4
       8.5
       8.6
       8.7
       8.8
       8.9
       8.10
       8.11
       8.12
    9 Data assignment rules
       9.1 Retrieval assignment
       9.2 Store assignment
       9.3 Set operation result data types
    10 Additional common elements
       10.1
       10.2
       10.3
       10.4
       10.5
       10.6 and
    11 Schema definition and manipulation
       11.1
       11.2
       11.3

       11.4
       11.5
       11.6

       11.7
       11.8
       11.9
       11.10
       11.11
       11.12
       11.13
       11.14
       11.15
       11.16
       11.17
       11.18
       11.19
       11.20
       11.21
       11.22
       11.23
       11.24
       11.25
       11.26
       11.27
       11.28
       11.29
       11.30
       11.31
       11.32
       11.33
       11.34
       11.35
       11.36
       11.37
    12 Module
       12.1
       12.2
       12.3
       12.4 Call to a
       12.5
    13 Data manipulation
       13.1
       13.2
       13.3
       13.4
       13.5
    Committee X3H2
    Development Note Supersedes ANSI INCITS 168. (05/2002)
    Document Type Standard
    Publisher Information Technology Industry Council
    Status Superseded
    Superseded By
    Supersedes

    Standards Referenced By This Book - (Show below) - (Hide below)

    CSA ISO/IEC 13818-6 : 2002 : R2010 INFORMATION TECHNOLOGY - GENERIC CODING OF MOVING PICTURES AND ASSOCIATED AUDIO INFORMATION - PART 6: EXTENSIONS FOR DSM-CC
    CSA ISO/IEC 13818-6 : 2002 INFORMATION TECHNOLOGY - GENERIC CODING OF MOVING PICTURES AND ASSOCIATED AUDIO INFORMATION - PART 6: EXTENSIONS FOR DSM-CC
    ANSI INCITS 168 : 1989 INFORMATION SYSTEMS - DATABASE LANGUAGE - EMBEDDED SQL
    ANSI INCITS 135.10 : 1998 INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 10: OBJECT LANGUAGE BINDINGS (SQL/OLB)
    ANSI INCITS 320 : 1998 INFORMATION TECHNOLOGY - SPATIAL DATA TRANSFER STANDARD (SDTS)
    AIIM MS60 : 0 ELECTRONIC FOLDER INTERCHANGE DATASTREAM
    ANSI INCITS 331.1 : 1999 INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQLJ - PART 1: SQL ROUTINES USING THE JAVA PROGRAMMING LANGUAGE
    CSA ISO/IEC 13818-6 : 2002 : INC : AMD 3 : 2003 : R2015 INFORMATION TECHNOLOGY - GENERIC CODING OF MOVING PICTURES AND ASSOCIATED AUDIO INFORMATION - PART 6: EXTENSIONS FOR DSM-CC
    ISO/IEC 13818-6:1998 Information technology — Generic coding of moving pictures and associated audio information — Part 6: Extensions for DSM-CC

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

    ANSI INCITS 9 : 78(R1989) PROGRAMMING LANGUAGE FORTRAN
    ISO/IEC 10646:2014 Information technology Universal Coded Character Set (UCS)
    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)
    MIL-STD-1815 Revision A:1983
    IEEE 770X3.160-1989 IEEE/ANSI Standard for the Programming Language Extended Pascal
    ISO 8601:2004 Data elements and interchange formats Information interchange Representation of dates and times
    ANSI INCITS 159 : 1989 "C" PROGRAMMING LANGUAGE
    ISO/IEC 9579-2:1998 Information technology — Open Systems Interconnection — Remote Database Access — Part 2: SQL Specialization
    ANSI INCITS 23 : 1985 PROGRAMMING LANGUAGE - COBOL
    ANSI INCITS 198 : 1992 PROGRAMMING LANGUAGE - FORTRAN - EXTENDED
    ISO/IEC 646:1991 Information technology ISO 7-bit coded character set for information interchange
    MDC X11.1 : 1995 INFORMATION SYSTEMS - PROGRAMMING LANGUAGES - MUMPS
    • 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