• INCITS/ISO/IEC 9075-5 : 1999

    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 - PART 5: HOST LANGUAGE BINDINGS (SQL/BINDINGS)

    Available format(s):  Hardcopy, PDF

    Withdrawn date:  23-07-2013

    Language(s): 

    Published date:  01-01-1999

    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 Catalogs
       4.2 SQL-client modules
       4.3 SQL-invoked routines
       4.4 Locators
       4.5 Cursors
       4.6 SQL-statements
       4.7 Standard programming languages
       4.8 Embedded syntax
       4.9 SQL dynamic statements
       4.10 Direct invocation of SQL
       4.11 Privileges and roles
       4.12 SQL-transactions
       4.13 SQL-connections
       4.14 SQL-sessions
       4.15 Client-server operation
    5 Lexical elements
       5.1 and
       5.2
       5.3 Names and identifiers
    6 Scalar expressions
       6.1 and
       6.2
       6.3
    7 Query expressions
       7.1


       7.2
    8 Additional common elements
       8.1
    9 Data assignment rules and routine determination
       9.1 Retrieval assignment
       9.2 Store assignment
       9.3 Data types of results of aggregations
    10 Schema definition and manipulation
       10.1
       10.2
       10.3
       10.4
       10.5
    11 SQL-client modules
       11.1
       11.2 Calls to an
       11.3
    12 Data manipulation
       12.1
       15.10
       15.11
       15.12
       15.13
       15.14
       15.15
       15.16
       15.17
       15.18
       15.19
       15.20
       15.21
       15.22
    16 Embedded SQL
       16.1
       16.2
       16.3
       16.4
       16.5
       16.6
       16.7
       16.8
       16.9
    17 Direct invocation of SQL
       17.1
       17.2
    18 Diagnostics management
       18.1
    19 Definition Schema
       19.1 SQL_LANGUAGES base table
    20 Status codes
       20.1 SQLSTATE
    21 Conformance
       21.1 General conformance requirements
       21.2 Claims of conformance
    Annex A SQL Conformance Summary
    Annex B Implementation-defined elements
    Annex C Implementation-dependent elements
    Annex D Deprecated features
    Annex E Incompatibilities with ISO/IEC 9075:1992
    Annex F SQL feature and package taxonomy
    Index

    Abstract - (Show below) - (Hide below)

    Describes syntax for embedding SQL-statements in a compilation unit that otherwise conforms to the standard for a particular programming language (host language).

    Development Note Partially supersedes ANSI INCITS 135. (02/2003)
    Document Type Standard
    Publisher Information Technology Industry Council
    Status Withdrawn
    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 7185:1990 Information technology Programming languages Pascal
    ISO/IEC 1989:2014 Information technology — Programming languages, their environments and system software interfaces — Programming language COBOL
    ISO/IEC 11756:1999 Information technology Programming languages M
    ISO/IEC 10206:1991 Information technology Progamming languages Extended Pascal
    ISO/IEC 1539-1:2010 Information technology Programming languages Fortran Part 1: Base language
    ISO/IEC 9899:2011 Information technology Programming languages C
    ISO/IEC 9075-3:2016 Information technology — Database languages — SQL — Part 3: Call-Level Interface (SQL/CLI)
    ISO 6160:1979 Programming languages PL/1
    ISO/IEC 8652:2012 Information technology — Programming languages — Ada
    ISO/IEC 9075-4:2016 Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)
    ISO/IEC 9075-1:2016 Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework)
    • 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