BS ISO/IEC 9075-9:2001

Name: BS ISO/IEC 9075-9:2001
Brand: BSI

Withdrawn

View Superseded by

Information technology. Database languages. SQL Management of external data (SQL/MED)

Withdrawn date

01-01-2006

Published date

08-15-2001

Publisher

British Standards Institution

Foreword
Introduction
1 Scope
2 Normative references
   2.1 ISO/IEC JTC 1 standards
   2.2 Publicly-available specifications
3 Definitions, notations, and conventions
   3.1 Definitions
   3.2 Notations
   3.3 Conventions
   3.4 Object identifier for Database Language SQL
4 Concepts
   4.1 SQL-environments and their components
   4.2 Data types
   4.3 Foreign servers
   4.4 Foreign-data wrappers
   4.5 User mappings
   4.6 Generic options
   4.7 Capabilities and options information
   4.8 Datalinks
   4.9 Type conversion and mixing of data types
   4.10 Columns, fields, and attributes
   4.11 Tables
   4.12 Functional dependencies
   4.13 SQL-schemas
   4.14 SQL-statements
   4.15 SQL-sessions
   4.16 Privileges
   4.17 SQL-transactions
   4.18 Foreign-data wrapper interface
   4.19 Introduction to SQL/CLI
5 Lexical elements
   5.1 and
   5.2 Names and identifiers
6 Scalar expressions
   6.1
   6.2
   6.3
   6.4
   6.5
   6.6
   6.7
   6.8
7 Query expressions
   7.1

   7.2
   7.3
   7.4
   7.5
8 Predicates
   8.1
9 URLs
   9.1 URL format
10 Data assignment rules and routine determination
   10.1 Retrieval assignment
   10.2 Store assignment
   10.3 Data types of results of aggregations
   10.4 Type precedence list determination
   10.5 Determination of identical values
11 Additional common elements
   11.1
   11.2
   11.3
12 Schema definition and manipulation
   12.1
   12.2
   12.3

   12.4
   12.5
   12.6
   12.7
   12.8
   12.9
   12.10
   12.11
   12.12
   12.13
   12.14
   12.15
   12.16
   12.17
13 Catalog manipulation
   13.1
   13.2
   13.3
   13.4
   13.5
   13.6
   13.7
14 Access control
   14.1
   14.2
   14.3
   14.4
15 SQL-client modules
   15.1
   15.2
   15.3 Calls to an
   15.4
   15.5 Data type correspondences
16 Data manipulation
   16.1
   16.2 Effect of deleting rows from base tables
   16.3 Effect of inserting tables into base tables
   16.4 Effect of replacing rows in base tables
17 Session management
   17.1
18 Dynamic SQL
   18.1 Description of SQL descriptor areas
   18.2
   18.3
   18.4
   18.5
   18.6
   18.7
   18.8
   18.9
   18.10
   18.11
   18.12
19 Embedded SQL
   19.1
   19.2
   19.3
   19.4
   19.5
   19.6
   19.7
20 Call-Level Interface specifications
   20.1
   20.2 Implicit DESCRIBE USING clause
   20.3 SQL/CLI data type correspondences
21 SQL/CLI routines
   21.1 BuildDataLink
   21.2 GetDataLinkAttr
   21.3 GetInfo
22 SQL/MED common specifications
   22.1 Description of foreign-data wrapper item descriptor
          areas
   22.2 Implicit cursor
   22.3 Implicit DESCRIBE INPUT USING clause
   22.4 Implicit DESCRIBE OUTPUT USING clause
   22.5 Implicit EXECUTE USING and OPEN USING clauses
   22.6 Implicit FETCH USING clause
   22.7 Character string retrieval
   22.8 Binary large object string retrieval
   22.9 Tables used with SQL/MED
23 Foreign-data wrapper interface routines
   23.1
   23.2 invocation
   23.3 Foreign-data wrapper interface wrapper routines
   23.4 Foreign-data wrapper interface SQL-server routines
   23.5 Foreign-data wrapper interface general routines
24 Diagnostics management
   24.1
25 Information Schema
   25.1 ATTRIBUTES view
   25.2 COLUMN_OPTIONS view
   25.3 COLUMNS view
   25.4 FOREIGN_DATA_WRAPPER_OPTIONS view
   25.5 FOREIGN_DATA_WRAPPERS view
   25.6 FOREIGN_SERVER_OPTIONS view
   25.7 FOREIGN_SERVERS view
   25.8 FOREGN_TABLES_OPTIONS view
   25.9 FOREGN_TABLES view
   25.10 USER_MAP_OPTIONS view
   25.11 USER_MAPPINGS view
   25.12 Short name views
26 Definition Schema
   26.1 COLUMN_OPTIONS base table
   26.2 DATA_TYPE_DESCRIPTOR base table
   26.3 FOREIGN_DATA_WRAPPER_OPTIONS base table
   26.4 FOREIGN_DATA_WRAPPERS base table
   26.5 FOREIGN_SERVER_OPTIONS base table
   26.6 FOREIGN_SERVERS base table
   26.7 FOREIGN_TABLE_OPTIONS base table
   26.8 FOREIGN_TABLE base table
   26.9 SQL_SIZING base table
   26.10 TABLES base table
   26.11 USAGE_PRIVILEGES base table
   26.12 USER_MAPPING_OPTIONS base table
   26.13 USER_MAPPING base table
27 Status codes
   27.1 SQLSTATE
28 Conformance
   28.1 SQL-server conformance to SQL/MED
   28.2 Foreign-data-wrapper conformance to SQL/MED
   28.3 Claims of conformance by SQL-servers
   28.4 Claims of conformance by foreign-data wrappers
   28.5 Extensions and options
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 Typical header files
      F.1 C Header File SQLCLI.H
      F.2 COBOL Library Item SQLCLI
Annex G SQL feature and package taxonomy
Annex H SQL/MED model
Index

Describes extensions to Database Language SQL to support management of external data through the use of foreign-data wrappers and datalink types.

Committee	IST/40
DevelopmentNote	Supersedes 99/656686 DC. (09/2002)
DocumentType	Standard
PublisherName	British Standards Institution
Status	Withdrawn
SupersededBy	BS ISO/IEC 9075 1-4,9-11,13-14:2003
Supersedes	99/656686 DC : DRAFT JAN 2000

Standards	Relationship
ISO/IEC 9075-9:2016	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 9075-5:1999	Information technology Database languages SQL Part 5: Host Language Bindings (SQL/Bindings)
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)