• Shopping Cart
    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

Language(s)

English

Published date

15-07-2000

Withdrawn date

15-06-2001

€395.12
Excluding VAT
Summarise this standard

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

⚠

This standard has been withdrawn and is no longer current. No replacement edition is available.

€395.12
Excluding VAT