ISO/IEC 9579:2000
(Main)Information technology — Remote database access for SQL with security enhancement
Information technology — Remote database access for SQL with security enhancement
This International Standard, Remote Database Access for SQL (RDA), defines a model for the remote interaction of an SQL-client and one or more SQL-servers through communication media, and defines the encoding of messages, the semantics of messages and associated facilities for mediating the interaction between one SQL-client and one SQL-server. This International Standard also defines a mapping of the RDA Protocol to the specific communication inhastructures TCPIIP and Transport Layer Security (TLS). This International Standard relies upon the facilities provided by ISOIIEC 9075 (SQL) and ISOIIEC 9075-3 (SQLICLI). This International Standard also: - identifies potential security vulnerabilities in remote database access using RDA, - defines RDA facilities which protect against the potential vulnerabilities. Normative annexes provide: - a Conformance Proforma, - an optional language independent Application Programming Interface defined in the notational conventions of ISOIIEC 9075-3 (SQLICLI) for invoking RDA Operations, - an optional mapping of ISOIIEC 9075-3 (SQLICLI) functions to RDA Operations, - definitions of optional SQL-servers, the RDA Location Server and the RDA Support Server, to facilitate interoperation and data distribution in a heterogeneous environment, - a set of security profiles that identify which RDA facilities and other security facilities are required for different levels of protection against potential vulnerabilities. Informative annexes provide: - an analysis of security service requirements, - an ASN. 1 specification for the RDA Protocol, - an ASN. 1 specification for the encoding of multiple rows. This International Standard does not constrain: - conforming RDA-client environments to be implemented using any particular processor decomposition, - conforming RDA-server environments to be implemented using any particular processor decomposition. This International Standard refers to but does not define: - protocols and security mechanisms for communication confidentiality, integrity and authentication of communicating peers, - digital signature and authentication mechanisms supported by protocol elements of RDA. This International Standard does not define: ? algorithms for query decomposition or for the combining of results in a distributed database environment, ? mechanisms for recovery in the event that transaction co-ordination fails, ? mechanisms for storage integrity and confidentiality using cryptography, ? mechanisms to counter Denial of Service attacks.
Technologies de l'information — Accès à la base de données à distance pour SQL avec sécurité accrue
General Information
Relations
Buy Standard
Standards Content (Sample)
INTERNATIONAL ISO/IEC
STANDARD 9579
Second edition
2000-02-15
Information technology — Remote
database access for SQL with security
enhancement
Technologies de l'information — Accès à la base de données à distance
pour SQL avec sécurité accrue
Reference number
ISO/IEC 9579:2000(E)
©
ISO/IEC 2000
---------------------- Page: 1 ----------------------
ISO/IEC 9579:2000(E)
PDF disclaimer
This PDF file may contain embedded typefaces. In accordance with Adobe's licensing policy, this file may be printed or viewed but shall not
be edited unless the typefaces which are embedded are licensed to and installed on the computer performing the editing. In downloading this
file, parties accept therein the responsibility of not infringing Adobe's licensing policy. The ISO Central Secretariat accepts no liability in this
area.
Adobe is a trademark of Adobe Systems Incorporated.
Details of the software products used to create this PDF file can be found in the General Info relative to the file; the PDF-creation parameters
were optimized for printing. Every care has been taken to ensure that the file is suitable for use by ISO member bodies. In the unlikely event
that a problem relating to it is found, please inform the Central Secretariat at the address given below.
© ISO/IEC 2000
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means, electronic
or mechanical, including photocopying and microfilm, without permission in writing from either ISO at the address below or ISO's member body
in the country of the requester.
ISO copyright office
Case postale 56 � CH-1211 Geneva 20
Tel. + 41 22 749 01 11
Fax + 41 22 734 10 79
E-mail copyright@iso.ch
Web www.iso.ch
Printed in Switzerland
ii © ISO/IEC 2000 – All rights reserved
---------------------- Page: 2 ----------------------
(E) 2000 ©
. . . . . .i
. . . . .iiiv
. . . . . ix
d. . . . .x
n. . . . .ix
1 Scope. . . . .1
2 s. . . .3
2.1 . . . .3
2.2 . . .3
2.3 s. . .4
3 y. . . .5
3.1 s. . .5
3.2 s. .5
3.3 s. . .5
4 s. . .6
4.1 s. . . .6
4.2 s. . . .7
4.2.1 s. . . .7
4.2.2 s. . . .7
4.2.3 s. . . .7
4.2.4 s.7
4.2.5 s. . . .7
iii
Remote Database Access for SQL (RDA/SQL)
Evaluation of Rule
tion of RDA Protocol, RDA Operations and RDA encoding element Specifica
Naming of Parameter
Naming of Concept
Convention for Figure
Convention
Definition
Definitions, Conventions and Notation
Interoperability with future edition
rability with conforming OSI implementation Interope
Interoperability between implementation
Interoperabilit
Institute of Electrical and Electronics Engineer
Internet Engineering Task Force
International Standards
Normative Reference
Introductio
Forewor
Figures
Tables
ii Contents
Contents
ISO/IEC 9579: ISO/IEC
---------------------- Page: 3 ----------------------
ISO/IEC 9579:2000 (E) © ISO/IEC
4.3 s. . . .9
4.3.1 s. . . .9
4.3.2 s. . . .9
4.3.3 s. . . .9
4.3.4 x. . .9
5 s. . . .10
5.1 l. . . . .10
5.2 -t. . .11
5.2.1 r. . . .11
5.2.2 SQL-s. . . .11
5.2.3 -client Services. . . .12
5.2.4 g. . . .12
5.2.5 -client. . . .12
5.2.6 . . . .13
5.3 -t. . .14
5.3.1 g. . . .14
5.3.2 -server Services. . . .14
5.3.3 -server. . . .15
5.3.4 SQL-r. . . .15
5.3.5 r. . . .15
5.4 s. .16
5.4.1 s. . .16
5.4.1.1 s. . . .16
5.4.1.2 s. . . .16
5.4.1.3 s. . . .16
5.4.2 T. . . .17
5.4.3 SQL--n. . .17
5.4.4 . . .17
5.4.5 -. . . .17
5.4.6 s. . . .17
5.4.7 t. . . .18
5.4.8 t. . . .18
5.4.9 t. . . .18
5.4.10 s. . . .18
5.5 t. . . .19
5.5.1 r. . . .19
5.5.2 s. . . .19
5. 5.3 -e. . .19
5.5.4 n. . . .19
5.5.5 s. . . .19
5.6 s. . .21
5.6.1 y. . .21
5.6.2 y. . . .21
5.7 -n. . .22
5.7.1 - Facility. . .22
vi
Contents
ordination RDA Transaction Co
ordinatio RDA Facilities for Transaction Co
RDA Encoding Facilit
RDA Suspend and Resume Facilit
RDA Facilities for Transport Connection
Transport Facilitie
Transport Connectio
server Nam Destination SQL
Transport Addres
Transport Provide
RDA Model of Transpor
Encoding
Request Iden
Statement Iden
Connection Iden
SQL/CLI Handle
site Transactions Multi
SQL User Name and Password
connectio session and SQL
SQL_TEX
Descriptor area
Diagnostics area
Attribute
Application Communication Area
RDA concepts and the mapping of SQL/CLI concept
RDA Support Serve
serve
RDA
RDA
rt Mappin Transpo
server environmen The RDA
RDA Location Server
RDA
Transport Mappin
RDA
client Service
Service Use
client environmen The RDA
Mode
Model and Facilitie
Notation for encoding synta
Encoding Attribute
Implicit encoding definition
SQL/CLI function
Notation
---------------------- Page: 4 ----------------------
ISO/IEC ISO/IEC 9579:2000 (E)©
5.8 y. . . .23
5.8.1 s. . . .23
5.8.2 s. . .23
5. 8.3 t. . .24
5.8.4 e. . .24
6 l. . . .26
6.1 e. . .26
6.2 e. . . .27
6.2.1 t. . .27
6.2.2 t. . .30
6.3 s. . .32
6.3.1 -t. .32
6.3.2 -t. .33
6.3.3 -server ent. .34
6.3.4 -. .35
6.3.5 n. . . .35
7 . . . .37
7.1 s. . . .37
7.1.1 n. . . .37
7.1.2 . . . .40
7.1.3 n. . . .41
7.1.4 n. . .43
7.1.5 n. . .44
7.1.6 n. . .45
7.1.7 n. . .46
7.1.8 n. . .49
7.1.9 n. . .50
7.1.10 n. . .52
7.1.11 n. . .53
7.1.12 n. . .54
7.1.13 n. . .55
7.1.14 n. . . .56
7.1.15 n. . .57
7.2 t. . .58
7.3 s. . . .62
7.3.1 t. . .62
7.3.2 . .65
7.3.3 t. . .66
7.3.4 s. . .68
8 s. . . . .69
8.1 -s. . .69
v
ase Access for SQL (RDA/SQL) Remote Datab
specific Condition Exception codes for RDA
Exception
RDARow and RDAValue encoding element
RDAItemDescriptor encoding elemen
d RDADiagnosticStatus encoding elements RDADiagnostic an
RDAAttribute encoding elemen
Encoding component
RDA response encoding elemen
eratio RDAGetTypeInfo Op
RDAGetInfo Operatio
RDAGetCursorName Operatio
RDASetCursorName Operatio
io RDAStatementCancel Operat
RDAStatementCloseCursor Operatio
RDAStatementFetchRows Operatio
RDAStatementExecDirect Operatio
RDAStatementExecute Operatio
RDAStatementDeallocate Operatio
RDAStatementPrepare Operatio
Attribute Operatio RDAClient
RDAEndTran Operatio
RDADisconnect Operation
RDAConnect Operatio
RDA request operation
RDA Operations
Transport Fail Indicatio
client environment Evaluation of the Response in the RDA
vironmen Invocation of the Response in the RDA
server environmen Evaluation of the Request in the RDA
client environmen Invocation of the Request in the RDA
Invocation of RDA Operation
MessageAuthentication encoding elemen
RDAMessage protocol elemen
RDAMessag
The RDA Protocol Exchang
RDA Protoco
Use of MessageAuthentication in RDAMessag
Use of Authentication in RDAConnec
Use of Transport Provider security facilitie
RDA Security Service
RDA Facilities for Securit
---------------------- Page: 5 ----------------------
ISO/IEC 9579:2000 (E) © ISO/IEC
8.2 r. . . .70
9 s. . . . .71
9.1 g. . . .72
9.2 g. . . .73
10 s. . . .74
10.1 P. . . .75
10.1.1 s. . . .75
10.1.2 nect. . .75
10.1.3 t. . .75
10.1.4 l. . . .75
10.1.5 d. . . .75
10.1.6 of Transport Receive. . .75
10.1.7 s. . .75
10.1.8 g. . . .75
10.2 . . . .76
10.2.1 t. . .76
10.2.2 s. . . .76
10.2.3 s. . .76
10.2.4 s. . .76
10.2.5 s. . .76
11 e. . . .77
11.1 -client Conformance. . . .77
11.2 -e. . . .77
11.3 e. . . .77
a. . . .79
n. . . .79
s. . . .79
s. . . .80
t. . . .80
-clients only. . .81
-servers only. . .82
e. . .83
B.1. s. . .84
B.2. e. . .84
B.3. s. . . .84
iv
Contents
Transport Handle
Mapping RDA/API to a programming languag
Notation for defining RDA/API function
gramming Interfac RDA Pro Annex B
Optional facilities for RDA A.6.
Optional facilities for RDA A.5.
RDA Suppor A.4.
Implementation Detail A.3.
Supplier Detail A.2.
Identificatio A.1.
Conformance Proform Annex A
Claims of Conformanc
server Conformanc RDA
RDA
Conformanc
Provision of optional security facilitie
Provision of mandatory security facilitie
Mapping of Transport Error
Mapping of encoding
port Connec Mapping of Trans
Mapping to TLS
Default Encodin
Mapping of Transport Error
Mapping
Mapping of Transport Sen
Mapping of Transport Fai
Mapping of Transport Disconnec
Mapping of Transport Con
Transport Addres
Mapping to TCP/I
Transport Mapping
The ASN.1 PER Encodin
The Base Encodin
Encoding
Exception Behaviou
---------------------- Page: 6 ----------------------
ISO/IEC ISO/IEC 9579:2000 (E)©
B.4. s. . . .84
B.5. t. . .85
B.6. s. . . .85
B.7. n. . .85
B.8. s. . .86
I. . . .93
C.1. t. . . .94
C.2. n. . . .94
C.3. r. .94
C.4. >. . . .95
r. . . .97
D.1. a. . .97
D.2. e. . . .98
r. . . .99
E.1. a. . .99
E.2. e. . . .99
E.3. e. . . .101
s. . .103
F.1. s. . . .103
F.2. n. . . .104
F.3. l. . . .105
F.4. y. . . .106
F.5. y. . . .106
F.6. y. . . .106
F.7. y. . . .107
F.8. -repudiation. . . .107
s. . . .109
n. .111
s. . .115
vii
ase Access for SQL (RDA/SQL) Remote Datab
Encoding of Multiple Row Annex I
RDA Operations and Protocol in ASN.1 notatio Annex H
Security Profile Annex G
Non
identialit Storage Conf
Storage Integrit
Transfer Confidentialit
Transfer Integrit
Access Contro
Authenticatio
Potential Vulnerabilitie
Security Service Requirement Annex F
Request Log Tabl
Server Information Tabl
RDA Support Server name and schem
RDA Support Serve Annex E
Server Location Tabl
RDA Location Server name and schem
RDA Location Serve Annex D
r, SQLSetStmtAttr and SQLSetEnvAtt SQLSetConnectAtt
SQLEndTra
SQLDisconnec
Mapping of SQL/CL Annex C
RDA/API function parameter
RDA/API function invocatio
RDA/API function
Transport Connection Managemen
Transport Mapping Code
---------------------- Page: 7 ----------------------
0 (E)2 ©
Tables
–l. . .27
–n. . .27
3– . . .28
–s. . .31
– 9075-3. . .41
–s. . .62
–s. .62
–s. . . .63
– 9075-3. . .63
–t. . . .64
–s. .66
–-tions. .69
–s. .70
–g. . .71
–s. . . .74
–s. . . .84
– . .93
– –d. . .109
– – . . .109
iv
ii Tables
Services Provided Security Profile Table G.2
Facilities Use Security Profiles Table G.1
RDA Operations invoked when evaluating an SQL/CLI function Table C.1
Transport Mapping Code Table 16
Transport Mapping Table 15
Codes used to identify TCP/IP encodin Table 14
RDAResponse Parameter settings for RDA generated condition Table 13
specific condi SQLSTATE class and subclass values for RDA Table 12
RDADescriptorEntries required for SQL Data Type Table 11
Values of Statement Iden Table 10
Extension to Table 19 of ISO/IEC Table 9
Prohibited attribute Table 8
Codes used for RDA defined Connection Attribute Table 7
for attribute type Codes used Table 6
Extension to Table 14 of ISO/IEC Table 5
Use of MessageAuthenticateParameter Table 4
Codes used to identify an RDA message type Table
Codes used to identify the protocol versio Table 2
Codes used to identify the protoco Table 1
ISO/IEC 9579:00
ISO/IEC
---------------------- Page: 8 ----------------------
ISO/IEC ISO/IEC 9579:2000 (E)©
Figures
–-t. . .10
–-t. . .11
–t. . .14
ix
ase Access for SQL (RDA/SQL) Remote Datab
Model of the RDA server environmen Figure 3
client environmen Model of the RDA Figure 2
environmen RDA model of SQL Figure 1
---------------------- Page: 9 ----------------------
0259 CEI/O ©
Foreword
ISO (the International Organization for Standardization) and IEC (t
...
INTERNATIONAL ISO/IEC
STANDARD 9579
Second edition
2000-02-15
Information technology — Remote
database access for SQL with security
enhancement
Technologies de l'information — Accès à la base de données à distance
pour SQL avec sécurité accrue
Reference number
ISO/IEC 9579:2000(E)
©
ISO/IEC 2000
---------------------- Page: 1 ----------------------
ISO/IEC 9579:2000(E)
PDF disclaimer
This PDF file may contain embedded typefaces. In accordance with Adobe's licensing policy, this file may be printed or viewed but shall not
be edited unless the typefaces which are embedded are licensed to and installed on the computer performing the editing. In downloading this
file, parties accept therein the responsibility of not infringing Adobe's licensing policy. The ISO Central Secretariat accepts no liability in this
area.
Adobe is a trademark of Adobe Systems Incorporated.
Details of the software products used to create this PDF file can be found in the General Info relative to the file; the PDF-creation parameters
were optimized for printing. Every care has been taken to ensure that the file is suitable for use by ISO member bodies. In the unlikely event
that a problem relating to it is found, please inform the Central Secretariat at the address given below.
© ISO/IEC 2000
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means, electronic
or mechanical, including photocopying and microfilm, without permission in writing from either ISO at the address below or ISO's member body
in the country of the requester.
ISO copyright office
Case postale 56 � CH-1211 Geneva 20
Tel. + 41 22 749 01 11
Fax + 41 22 734 10 79
E-mail copyright@iso.ch
Web www.iso.ch
Printed in Switzerland
ii © ISO/IEC 2000 – All rights reserved
---------------------- Page: 2 ----------------------
(E) 2000 ©
. . . . . .i
. . . . .iiiv
. . . . . ix
d. . . . .x
n. . . . .ix
1 Scope. . . . .1
2 s. . . .3
2.1 . . . .3
2.2 . . .3
2.3 s. . .4
3 y. . . .5
3.1 s. . .5
3.2 s. .5
3.3 s. . .5
4 s. . .6
4.1 s. . . .6
4.2 s. . . .7
4.2.1 s. . . .7
4.2.2 s. . . .7
4.2.3 s. . . .7
4.2.4 s.7
4.2.5 s. . . .7
iii
Remote Database Access for SQL (RDA/SQL)
Evaluation of Rule
tion of RDA Protocol, RDA Operations and RDA encoding element Specifica
Naming of Parameter
Naming of Concept
Convention for Figure
Convention
Definition
Definitions, Conventions and Notation
Interoperability with future edition
rability with conforming OSI implementation Interope
Interoperability between implementation
Interoperabilit
Institute of Electrical and Electronics Engineer
Internet Engineering Task Force
International Standards
Normative Reference
Introductio
Forewor
Figures
Tables
ii Contents
Contents
ISO/IEC 9579: ISO/IEC
---------------------- Page: 3 ----------------------
ISO/IEC 9579:2000 (E) © ISO/IEC
4.3 s. . . .9
4.3.1 s. . . .9
4.3.2 s. . . .9
4.3.3 s. . . .9
4.3.4 x. . .9
5 s. . . .10
5.1 l. . . . .10
5.2 -t. . .11
5.2.1 r. . . .11
5.2.2 SQL-s. . . .11
5.2.3 -client Services. . . .12
5.2.4 g. . . .12
5.2.5 -client. . . .12
5.2.6 . . . .13
5.3 -t. . .14
5.3.1 g. . . .14
5.3.2 -server Services. . . .14
5.3.3 -server. . . .15
5.3.4 SQL-r. . . .15
5.3.5 r. . . .15
5.4 s. .16
5.4.1 s. . .16
5.4.1.1 s. . . .16
5.4.1.2 s. . . .16
5.4.1.3 s. . . .16
5.4.2 T. . . .17
5.4.3 SQL--n. . .17
5.4.4 . . .17
5.4.5 -. . . .17
5.4.6 s. . . .17
5.4.7 t. . . .18
5.4.8 t. . . .18
5.4.9 t. . . .18
5.4.10 s. . . .18
5.5 t. . . .19
5.5.1 r. . . .19
5.5.2 s. . . .19
5. 5.3 -e. . .19
5.5.4 n. . . .19
5.5.5 s. . . .19
5.6 s. . .21
5.6.1 y. . .21
5.6.2 y. . . .21
5.7 -n. . .22
5.7.1 - Facility. . .22
vi
Contents
ordination RDA Transaction Co
ordinatio RDA Facilities for Transaction Co
RDA Encoding Facilit
RDA Suspend and Resume Facilit
RDA Facilities for Transport Connection
Transport Facilitie
Transport Connectio
server Nam Destination SQL
Transport Addres
Transport Provide
RDA Model of Transpor
Encoding
Request Iden
Statement Iden
Connection Iden
SQL/CLI Handle
site Transactions Multi
SQL User Name and Password
connectio session and SQL
SQL_TEX
Descriptor area
Diagnostics area
Attribute
Application Communication Area
RDA concepts and the mapping of SQL/CLI concept
RDA Support Serve
serve
RDA
RDA
rt Mappin Transpo
server environmen The RDA
RDA Location Server
RDA
Transport Mappin
RDA
client Service
Service Use
client environmen The RDA
Mode
Model and Facilitie
Notation for encoding synta
Encoding Attribute
Implicit encoding definition
SQL/CLI function
Notation
---------------------- Page: 4 ----------------------
ISO/IEC ISO/IEC 9579:2000 (E)©
5.8 y. . . .23
5.8.1 s. . . .23
5.8.2 s. . .23
5. 8.3 t. . .24
5.8.4 e. . .24
6 l. . . .26
6.1 e. . .26
6.2 e. . . .27
6.2.1 t. . .27
6.2.2 t. . .30
6.3 s. . .32
6.3.1 -t. .32
6.3.2 -t. .33
6.3.3 -server ent. .34
6.3.4 -. .35
6.3.5 n. . . .35
7 . . . .37
7.1 s. . . .37
7.1.1 n. . . .37
7.1.2 . . . .40
7.1.3 n. . . .41
7.1.4 n. . .43
7.1.5 n. . .44
7.1.6 n. . .45
7.1.7 n. . .46
7.1.8 n. . .49
7.1.9 n. . .50
7.1.10 n. . .52
7.1.11 n. . .53
7.1.12 n. . .54
7.1.13 n. . .55
7.1.14 n. . . .56
7.1.15 n. . .57
7.2 t. . .58
7.3 s. . . .62
7.3.1 t. . .62
7.3.2 . .65
7.3.3 t. . .66
7.3.4 s. . .68
8 s. . . . .69
8.1 -s. . .69
v
ase Access for SQL (RDA/SQL) Remote Datab
specific Condition Exception codes for RDA
Exception
RDARow and RDAValue encoding element
RDAItemDescriptor encoding elemen
d RDADiagnosticStatus encoding elements RDADiagnostic an
RDAAttribute encoding elemen
Encoding component
RDA response encoding elemen
eratio RDAGetTypeInfo Op
RDAGetInfo Operatio
RDAGetCursorName Operatio
RDASetCursorName Operatio
io RDAStatementCancel Operat
RDAStatementCloseCursor Operatio
RDAStatementFetchRows Operatio
RDAStatementExecDirect Operatio
RDAStatementExecute Operatio
RDAStatementDeallocate Operatio
RDAStatementPrepare Operatio
Attribute Operatio RDAClient
RDAEndTran Operatio
RDADisconnect Operation
RDAConnect Operatio
RDA request operation
RDA Operations
Transport Fail Indicatio
client environment Evaluation of the Response in the RDA
vironmen Invocation of the Response in the RDA
server environmen Evaluation of the Request in the RDA
client environmen Invocation of the Request in the RDA
Invocation of RDA Operation
MessageAuthentication encoding elemen
RDAMessage protocol elemen
RDAMessag
The RDA Protocol Exchang
RDA Protoco
Use of MessageAuthentication in RDAMessag
Use of Authentication in RDAConnec
Use of Transport Provider security facilitie
RDA Security Service
RDA Facilities for Securit
---------------------- Page: 5 ----------------------
ISO/IEC 9579:2000 (E) © ISO/IEC
8.2 r. . . .70
9 s. . . . .71
9.1 g. . . .72
9.2 g. . . .73
10 s. . . .74
10.1 P. . . .75
10.1.1 s. . . .75
10.1.2 nect. . .75
10.1.3 t. . .75
10.1.4 l. . . .75
10.1.5 d. . . .75
10.1.6 of Transport Receive. . .75
10.1.7 s. . .75
10.1.8 g. . . .75
10.2 . . . .76
10.2.1 t. . .76
10.2.2 s. . . .76
10.2.3 s. . .76
10.2.4 s. . .76
10.2.5 s. . .76
11 e. . . .77
11.1 -client Conformance. . . .77
11.2 -e. . . .77
11.3 e. . . .77
a. . . .79
n. . . .79
s. . . .79
s. . . .80
t. . . .80
-clients only. . .81
-servers only. . .82
e. . .83
B.1. s. . .84
B.2. e. . .84
B.3. s. . . .84
iv
Contents
Transport Handle
Mapping RDA/API to a programming languag
Notation for defining RDA/API function
gramming Interfac RDA Pro Annex B
Optional facilities for RDA A.6.
Optional facilities for RDA A.5.
RDA Suppor A.4.
Implementation Detail A.3.
Supplier Detail A.2.
Identificatio A.1.
Conformance Proform Annex A
Claims of Conformanc
server Conformanc RDA
RDA
Conformanc
Provision of optional security facilitie
Provision of mandatory security facilitie
Mapping of Transport Error
Mapping of encoding
port Connec Mapping of Trans
Mapping to TLS
Default Encodin
Mapping of Transport Error
Mapping
Mapping of Transport Sen
Mapping of Transport Fai
Mapping of Transport Disconnec
Mapping of Transport Con
Transport Addres
Mapping to TCP/I
Transport Mapping
The ASN.1 PER Encodin
The Base Encodin
Encoding
Exception Behaviou
---------------------- Page: 6 ----------------------
ISO/IEC ISO/IEC 9579:2000 (E)©
B.4. s. . . .84
B.5. t. . .85
B.6. s. . . .85
B.7. n. . .85
B.8. s. . .86
I. . . .93
C.1. t. . . .94
C.2. n. . . .94
C.3. r. .94
C.4. >. . . .95
r. . . .97
D.1. a. . .97
D.2. e. . . .98
r. . . .99
E.1. a. . .99
E.2. e. . . .99
E.3. e. . . .101
s. . .103
F.1. s. . . .103
F.2. n. . . .104
F.3. l. . . .105
F.4. y. . . .106
F.5. y. . . .106
F.6. y. . . .106
F.7. y. . . .107
F.8. -repudiation. . . .107
s. . . .109
n. .111
s. . .115
vii
ase Access for SQL (RDA/SQL) Remote Datab
Encoding of Multiple Row Annex I
RDA Operations and Protocol in ASN.1 notatio Annex H
Security Profile Annex G
Non
identialit Storage Conf
Storage Integrit
Transfer Confidentialit
Transfer Integrit
Access Contro
Authenticatio
Potential Vulnerabilitie
Security Service Requirement Annex F
Request Log Tabl
Server Information Tabl
RDA Support Server name and schem
RDA Support Serve Annex E
Server Location Tabl
RDA Location Server name and schem
RDA Location Serve Annex D
r, SQLSetStmtAttr and SQLSetEnvAtt SQLSetConnectAtt
SQLEndTra
SQLDisconnec
Mapping of SQL/CL Annex C
RDA/API function parameter
RDA/API function invocatio
RDA/API function
Transport Connection Managemen
Transport Mapping Code
---------------------- Page: 7 ----------------------
0 (E)2 ©
Tables
–l. . .27
–n. . .27
3– . . .28
–s. . .31
– 9075-3. . .41
–s. . .62
–s. .62
–s. . . .63
– 9075-3. . .63
–t. . . .64
–s. .66
–-tions. .69
–s. .70
–g. . .71
–s. . . .74
–s. . . .84
– . .93
– –d. . .109
– – . . .109
iv
ii Tables
Services Provided Security Profile Table G.2
Facilities Use Security Profiles Table G.1
RDA Operations invoked when evaluating an SQL/CLI function Table C.1
Transport Mapping Code Table 16
Transport Mapping Table 15
Codes used to identify TCP/IP encodin Table 14
RDAResponse Parameter settings for RDA generated condition Table 13
specific condi SQLSTATE class and subclass values for RDA Table 12
RDADescriptorEntries required for SQL Data Type Table 11
Values of Statement Iden Table 10
Extension to Table 19 of ISO/IEC Table 9
Prohibited attribute Table 8
Codes used for RDA defined Connection Attribute Table 7
for attribute type Codes used Table 6
Extension to Table 14 of ISO/IEC Table 5
Use of MessageAuthenticateParameter Table 4
Codes used to identify an RDA message type Table
Codes used to identify the protocol versio Table 2
Codes used to identify the protoco Table 1
ISO/IEC 9579:00
ISO/IEC
---------------------- Page: 8 ----------------------
ISO/IEC ISO/IEC 9579:2000 (E)©
Figures
–-t. . .10
–-t. . .11
–t. . .14
ix
ase Access for SQL (RDA/SQL) Remote Datab
Model of the RDA server environmen Figure 3
client environmen Model of the RDA Figure 2
environmen RDA model of SQL Figure 1
---------------------- Page: 9 ----------------------
0259 CEI/O ©
Foreword
ISO (the International Organization for Standardization) and IEC (t
...
Questions, Comments and Discussion
Ask us and Technical Secretary will try to provide an answer. You can facilitate discussion about the standard in here.