• There are no items in your cart

BS ISO/IEC 9075-5:1999

Withdrawn

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 Host language bindings (SQL/Bindings)

Available format(s)

Hardcopy , PDF

Withdrawn date

15-06-2001

Language(s)

English

Published date

15-07-2000

€416.02
Excluding VAT

Foreword
Introduction
1 Scope
2 Normative references
3 Definitions, notations, and conventions
    3.1 Definitions
    3.2 Notation
    3.3 Conventions
          3.3.1 Use of terms
                  3.3.1.1 Other terms
          3.3.2 Relationships to other parts
                  of ISO/IEC 9075
                  3.3.2.1 Clause, Subclause, and
                            Table relationships
    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.6.1 Classes of SQL-statements
          4.6.2 SQL-statements classified by function
          4.6.3 SQL-statements and transaction states
          4.6.4 Embeddable SQL-statements
          4.6.5 Preparable and immediately executable
                  SQL-statements
          4.6.6 Directly executable 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           specification>
    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           positioned>
    15.22           positioned>
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
Annexes
A SQL Conformance Summary
B Implementation-defined elements
C Implementation-dependent elements
D Deprecated features
E Incompatibilities with ISO/IEC 9075:1992
F SQL feature and package taxonomy
Index
Tables
1 Clause, Subclause, and Table relationships
2 Data types of s used in the header of
    SQL descriptor areas
3 Data types of s used in SQL item
    descriptor areas
4 Codes used for SQL data types in Dynamic SQL
5 Codes associated with datetime data types in
    Dynamic SQL
6 Codes used for s in Dynamic SQL
7 Codes used for input/output SQL parameter modes in
    Dynamic SQL
8 s for use with     statement>
9 SQL-statement codes
10 SQLSTATE class and subclass values
11 Implied feature relationships
12 SQL/Bindings feature taxonomy and definition for
    Core SQL
13 SQL/Bindings feature taxonomy for features outside
    Core SQL

Defines syntax for embedding SQL-statements in a compilation unit that otherwise complies with the standard for a particular programming language. Also defines how an equivalent unit may be derived that complies with the particular programming language standard. Gives syntax for direct invocation of SQL-statements, and SQL language to support dynamic preparation and execution of SQL-statements.

Committee
IST/40
DevelopmentNote
Together with BS ISO/IEC 9075-1 and BS ISO/IEC 9075-2, Supersedes BS ISO/IEC 9075. (03/2000) Supersedes 97/645789 DC. (03/2007)
DocumentType
Standard
Pages
258
PublisherName
British Standards Institution
Status
Withdrawn
Supersedes

Standards Relationship
ISO/IEC 9075-5:1999 Identical

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, flexible and cost effective.