Customer Support: +1 416-401-8730

Login to i2i Subscription Intertek.com
  • There are no items in your cart
Please enter a keyword to search
Advanced search
Home
CSA
CSA ISO/IEC 9075 : 0

CSA ISO/IEC 9075 : 0

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

Available format(s)

Hardcopy , PDF

Withdrawn date

11-05-2003

Language(s)

English

Publisher

Canadian Standards Association

Foreword
Introduction
1 Scope
2 Normative references
3 Definitions, notations, and conventions
4 Concepts
5 Lexical elements
6 Scalar expressions
7 Query expressions
8 Predicates
9 Data assignment rules
10 Additional common elements
11 Schema definition and manipulation
12 Module
13 Data manipulation
14 Transaction management
15 Connection management
16 Session management
17 Dynamic SQL
18 Diagnostics management
19 Embedded SQL
20 Direct invocation of SQL
21 Information Schema and Definition Schema
22 Status codes
23 Conformance
Annex A Leveling the SQL Language
Annex B Implementation-defined elements
Annex C Implementation-dependent elements
Annex D Deprecated features
Annex E Incompatibilities with ISO/IEC 9075:1989
Annex F Maintenance and interpretation of SQL
Index
Tables

Defines the data structures and basic operations on SQL- data. Provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data. Specifies the syntax and semantics of a database language: - for specifying and modifying the structure and the integrity constraints of SQL-data, - for declaring and invoking operations of SQL-data and cursors, and - for declaring database language procedures and embedding them into a standard programming language. Also specifies an Information Schema that describes the structure and the integrity constraints of SQL-data. This standard: - provides a vehicle for portability of data definitions and compilation units between SQL-implementations, - provides a vehicle for interconnection of SQL-implementations, - specifies syntax for embedding SQL-statements in a compilation unit that otherwise conforms to the standard for a particular programming language. It defines how an equivalent compilation unit may be derived that conforms to the particular programming language standard. In that equivalent compilation unit, each embedded SQL-statement has been replaced by statements that invoke a database language procedure that contains the SQL-statement, and - specifies syntax for direct invocation of SQL-statements.

DevelopmentNote
Supersedes CSA Z243.47. (02/2008)
DocumentType
Standard
Pages
623
PublisherName
Canadian Standards Association
Status
Withdrawn
Supersedes

Standards Relationship
ISO/IEC 9075:1992 Similar to

ISO/IEC 10646:2014 Information technology Universal Coded Character Set (UCS)
ISO 7185:1990 Information technology Programming languages Pascal
ISO/IEC 2022:1994 Information technology Character code structure and extension techniques
ISO/IEC 8824:1990 Information technology — Open Systems Interconnection — Specification of Abstract Syntax Notation One (ASN.1)
ISO/IEC 1989:2014 Information technology — Programming languages, their environments and system software interfaces — Programming language COBOL
ISO 1539:1980 Programming languages FORTRAN
ISO/IEC 11756:1999 Information technology Programming languages M
ISO 8601:2004 Data elements and interchange formats Information interchange Representation of dates and times
ISO/IEC 10206:1991 Information technology Progamming languages Extended Pascal
ISO/IEC 9579-2:1998 Information technology — Open Systems Interconnection — Remote Database Access — Part 2: SQL Specialization
ISO/IEC 9899:2011 Information technology Programming languages C
ISO/IEC 646:1991 Information technology ISO 7-bit coded character set for information interchange
ISO 6160:1979 Programming languages PL/1
ISO/IEC 8652:2012 Information technology — Programming languages — Ada

View more information
US$355.00
Excluding Tax where applicable
USD
CAD
CHF
CNY
DKK
EUR
GBP
HKD
IDR
INR
JPY
KRW
MXN
NOK
NZD
SEK
SGD
USD
ZAR
Hardcopy - English
PDF - English
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

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.

Learn more on subscription solutions

or

Get in touch with us