BS ISO/IEC 9075-9:2001
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.
View Superseded by
Information technology. Database languages. SQL Management of external data (SQL/MED)
01-01-2006
15-08-2001
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
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
Committee |
IST/40
|
DevelopmentNote |
Supersedes 99/656686 DC. (09/2002)
|
DocumentType |
Standard
|
PublisherName |
British Standards Institution
|
Status |
Withdrawn
|
SupersededBy | |
Supersedes |
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) |
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.
Logging out.