BS ISO/IEC 9075-4:1999

Foreword
Introduction
1 Scope
2 Normative references
3 Definitions, notations, and conventions
    3.1 Definitions
          3.1.1 Definitions provided in Part 4
    3.2 Notations
    3.3 Conventions
          3.3.1 Use of terms
                  3.3.1.1 Exceptions
                  3.3.1.2 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 SQL-server modules
    4.2 SQL-invoked routines
    4.3 SQL-paths
    4.4 Tables
    4.5 SQL-schemas
    4.6 Host parameters
          4.6.1 Status parameters
    4.7 Diagnostics area
    4.8 Cursors
    4.9 Condition handling
    4.10 SQL-statements
          4.10.1 SQL-statements classified by function
          4.10.2 Embeddable SQL-statements
          4.10.3 Directly executable SQL-statements
          4.10.4 Iterated SQL-statements
          4.10.5 SQL-statements and transaction states
          4.10.6 Compound statements
          4.10.7 SQL-statement atomicity
    4.11 Basic security model
          4.11.1 Privileges
5 Lexical elements
    5.1 and
    5.2 Names and identifiers
6 Scalar expressions
    6.1 and
          
    6.2
    6.3
7 Query expressions
    7.1
8 Additional common elements
    8.1
    8.2
    8.3
9 Schema definition and manipulation
    9.1
    9.2
    9.3
    9.4
    9.5
    9.6
    9.7
    9.8
    9.9
    9.10
    9.11
    9.12
    9.13
    9.14
    9.15
    9.16
    9.17
    9.18
    9.19
    9.20
    9.21
    9.22
    9.23
10 Access control
    10.1
    10.2
11 SQL-client modules
    11.1 Calls to an
    11.2
12 Data manipulation
    12.1
    12.2
    12.3
    12.4
    12.5
    12.6
    12.7
13 Control statements
    13.1
    13.2
    13.3
    13.4
    13.5
    13.6
    13.7
    13.8
    13.9
    13.10
    13.11
    13.12
    13.13
14 Dynamic SQL
    14.1
15 Embedded SQL
    15.1
16 Diagnostics management
    16.1
    16.2
    16.3
17 Information Schema
    17.1 MODULE_COLUMN_USAGE view
    17.2 MODULE_PRIVILEGES view
    17.3 MODULE_TABLE_USAGE view
    17.4 MODULES view
    17.5 ROLE_MODULE_GRANTS view
    17.6 Short name views
18 Definition Schema
    18.1 MODULE_COLUMN_USAGE base table
    18.2 MODULE_PRIVILEGES base table
    18.3 MODULE_TABLE_USAGE base table
    18.4 MODULES base table
19 Status codes
    19.1 SQLSTATE
20 Conformance
    20.1 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 Taxonomy
Index
Tables
1 Clause, Subclause, and Table relationships
2 s for use with     statement>
3 SQL-statement codes for use in the diagnostics area
4 SQLSTATE class and subclass values
5 SQL/PSM feature taxonomy for features outside
    Core SQL

Abstract

Specifies the syntax and semantics of a database language for declaration and maintenance of persistent database language routines in SQL-server modules. Also defines the Information Schema tables containing schema information which relates to SQL-server modules and SQL-invoked routines.

General Product Information

Committee	IST/40
DevelopmentNote	Supersedes 97/645788 DC & 95/647012 DC. (03/2007)
DocumentType	Standard
Pages	168
PublisherName	British Standards Institution
Status	Withdrawn
Supersedes	BS ISO/IEC 9075-4:1996 95/647012 DC : NOV 95 97/645788 DC : NOV 97

International Equivalents

Standards	Relationship
ISO/IEC 9075-4:2016	Identical
ISO/IEC 9075-4:1999	Identical

Standards Referencing This Book

ISO/IEC 9075-2:2016	Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
ISO/IEC 9075-5:1999	Information technology Database languages SQL Part 5: Host Language Bindings (SQL/Bindings)
ISO/IEC 9075-3:2016	Information technology — Database languages — SQL — Part 3: Call-Level Interface (SQL/CLI)
ISO/IEC 8652:2012	Information technology — Programming languages — Ada
ISO/IEC 9075-1:2016	Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework)

Category

Subcategory

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.

Get in touch with us

Contact us

• 

  Intertek Inform
  c/o NSAI, 1 Swift Square,
  Northwood, Santry,
  Dublin 9, D09 A0E4
  Ireland

• 

  info@standards.ie

• 

  Monday to Friday 9:00am to 5.30pm GMT, excluding public holidays.

• 

  Call us on +353 (0)1 857 6730