ISO/IEC 9579:1999

INTERNATIONAL ISOIIEC
STANDARD 9579
First edition
1999-06- 15
Information technology - Remote
Database Access for SQL
Technologies de I’informa tion -Acc& & Ia base de donnkes a distance
pour SQL
Reference number
ISO/1 EC 9579: 1999(E)
ISO/IEC 9579: 1999 (E)
Contents
Contents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .~. ii
Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
. . .
Figures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .~. VI11
Foreword . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .~. ix
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .~. X
Introduction
Scope . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
2 Normative References . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
21 . International Standards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .~.“.~.~~~.”.~.~.~. 2
2' .L Internet Engineering Task Forte
Institute of Electrical and Electronics Engheers . .0.“. 3
23 .
3 Interoperability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
31 . Interoperability between implementations
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
32 . Interoperability with conforming Edition 2 implernentations
Interoperability with future editions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
33 .
4 Definitions, Conventions and Notations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
41 . Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
42 Convent ions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
4'2 . 1 Convention for Figures
4'2 . 2 Naming of Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
4'2 . 3 Narn ing of Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
4'2 . 4 Specification of RDA Protocol, RDA Operations and RDA encoding elements . . . . . . . . . . . . . . . . . . . . . . . . 6
4'2 . . 5 Evaluation of Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
0 ISO/IEC 1999
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or
utilized in any form or by any means. electronie or mechanical, including photocopying and micro-
film, without Permission in writing from the publisher.
ISO/IEC Copyright Office l Case postale 56 l CH- 12 11 Geneve 20 l Switzerland
Printed in Switzerland
ii Remote Database Access for SQL (RDA/SQL)

0 ISO/IEC
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .*.
43 Notations
. SQL/CLI functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4’3 1
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .‘.
4’3 . 2 Implicit encoding definitions
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4’3 . 3 Encoding Attributes
Notation for encoding Syntax . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
4’3 . . 4
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
51 . Model
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
The RDA-client environment
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5’2 . 1 Service User
SQL-client Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5’22 .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5’23 . RDA-client Services
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5’24 . Transport Mapping
RDA-client . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5’2 . 5
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
RDA Location Server
5’26 . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
The RDA-server environment
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5’3 . 1 Transport Mapping
RDA-server Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .*.
5’3 . 2
. RDA-server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5’3 3
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5’3 . 4 SQL-server
5’3 . . 5 RDA Support Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
54 RDA concepts and the mapping of SQL/CLI concepts
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5’4 1 Application Communication Areas
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5:4:1.1 Attributes
Diagnostics areas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5.4.1.2
5.4.1.3 Descriptor areas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .*.
5.4.2 SQL TEXT .
SQLGession and SQL-connection .
5.4.3
.................................................................................................
5.4.4 SQL User Name and Password
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5.4.5 Multi-site Transattions
5.4.6 SQWCLI Handles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .*
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5.4.7 Connection Ident
5.4.8 Statement Ident . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .*.*.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5.4.9 Request Ident
Encodings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .*.*.*.*
5.4.10
55 RDA Model of Transport .
.....................................................................................................................
5’5 . 1 Transport Provider
......................................................................................................................
5’5 . 2 Transport Address
...................................................................................................
. Destination SQL-server Name
5’5 3
................................................................................................................
5’5 . 4 Transport Connection
. . Transport Facilities .
5’5 5
................................................................................
56 RDA Facilities for Transport Connections
. RDA Suspend and Resume Facility .
5’6 1
.............................................................................................................
5’6 . . 2 RDA Encoding Facility
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
RDA Facilities for Transaction Co-Ordination.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
5’7 . . 1 RDA Transaction Co-Ordination Facility
Contents iii
0 ISO/IEC
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
58 . RDA Facilities for Security
Protocol ~~~O~~~O~~~~~**~~~~***~~~O*~~~.**~~~~.~~*~~~~O*~O****~*~O@*~~**@~~@O~~~~~O**~@~*~~*O~~~~.~~O.~O~~.O~*O~.~O~*~~~*~~~~@~O~O@*OO*O~~.~*~
6 RDA
.....................................................................................................
61 . The RDA Protocol Exchange
.................................................................................................
62 . RDAMessage protocol element
..................................................................................................
63 Invocation of RDA Operations
.......................................................
Invocation of the Request in the RDA-client environment
6’3 . 1
...................................................... 27
6’3 . 2 Evaluation of the Request in the RDA-server environment
....................................................
6’3 . 3 Invocation of the Response in the RDA-server environment
....................................................
Evaluation of the Response in the RDA-client environment
6’3 . 4
...........................................................................................................
6’3 . . 5 Transport Fail Indication
.............................................................................................................
71 RDA request operations
............................................................................................................
7’1 1 RDAConnect Operation
.
........................................................................................................
7’1 . 2 RDADisconnect Operation
............................................................................................................
RDAEndTran Operation
7’1 . 3
. .
7’1 . 4 RDAClientAttribute Operation
..............................................................................................
7’1 . 5 RDAStatementPrepare Operation
.........................................................................................
RDAStatementDeallocate Operation
7’1 . 6
.............................................................................................
7’1 . 7 RDAStatementExecute Operation
........................................................................................
7’1 . 8 RDAStatementExecDirect Operation
........................................................................................
RDAStatementFetchRows Operation
7’1 . 9
......................................................................................
7’1 . 10 RDAStatementCloseCursor Operation
...............................................................................................
7’1 . 11 RDAStatementCancel Operation
................................................................................................
RDASetCursorName Operation
7’1 . 12
................................................................................................
7’1 . 13 RDAGetCursorName Operation
.............................................................................................................
7’1 . 14 RDAGetInfo Operation
RDAGetTypeInfo Operation .
7’1 . . 15
...............................................................................................
72 . RDA response encoding element
................................................................................................................
73 Encoding components
RDAAttribute encoding element .
7’3 . 1
...............................................
7’3 . 2 RDADiagnostic and RDADiagnosticStatus encoding elements
.....................................................................................
7’3 . 3 RDAItemDescriptor encoding element
...........................................................................
RDARow and RDAValue encoding elements
7’3 . . 4
8 Exceptions ~~~~o~~~~~~~~~~~~~~~~~~~*~*~oe*~.o*~*~.*~~~*~~~~~~~~~~o*.*~*~~~~~*~*~~~~o~~o~o~ooo~*oo~o~.~~~.~~~~~~~~~~~~*~*~~.~.~~~~.o~~e.~~~~~*~o~.~~~
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
81 . Exception Codes for RDA-specific Conditions
Exception Behaviour . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
82 .
91 . The Base Encoding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
92 . The ASN. 1 PER Encoding
iv Remote Database Access for SQL (RDABQL)

ISO/IEC 9579: 1999 (E)
0 ISO/IEC
10 Transport Mappings e*ob~*8~*e*o~~o~.~******8*~**e*8**oe*o*~~***o*o***********e~***o8*oooeo*~*oo*oo****~o**e*o8o*oo*~*****~~o*****o8*b***~~** 66
10.1 Mapping to TCP/IP . 67
10.1.1 Transport Address .
Mapping of Transport Connect . 67
10.1.2
10.1.3 Mapping of Transport Disconnect .
......................................................................................................... 67
10.1.4 Mapping of Transport Fail
10.1.5 Mapping of Transport Send .
.................................................................................................. 67
10.1.6 Mapping of Transport Receive
Mapping of Transport Errors . 67
10.1.7
10.1.8 Default Encoding .
......................................................................................................................... 68
10.2 Mapping to TLS
Connect . 68
10.2.1 Mapping of Transport
10.2.2 Mapping of encodings .
..................................................................................................... 68
10.2.3 Mapping of Transport Errors
~o**m**~~~~.**~*8*8.~~8*~~~~~~*e~~*o**o~~~8~~.o*o*o*.**.****~*~*****~**o****88**~*o*o********o*oo***~.o8~~.****~****oe*o***eoo***~**om
11 Conformance
11.1 RDA-client Conformance . . . .*.*.*.
11.2 RDA-server Conformance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
11.3 Claims of Conformance
Annex A Conformance Proforma o**o*b*~o.b.o*o*o*o*o*o***o**~~~oo*******o~.**~o*********o******.*o*8**~*****~*****~b****o~*~**~o~*m~8****
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Al . . Identification
Supplier Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .*.
A.2.
. . . . . . . . . . . .*.*.*. 72
A3 . . Implementation Details
RDA Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
A.4.
only . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
A.5. Optional facilities for RDA-clients
Optional facilities for RDA-servers only . . . . . . . . . . . . . . . . . . . . . . .*.
A.6.
Annex B RDA Programming Interface **~~e0b0e*****~*0**80*0*0*0~~0*~**8*0*0*0*~0****80~*e**0*8**********~*~~*~**0e*0*~88~***~0~**~~~*
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Bl . . Notation for defining RDA/API functions
Mapping RDA/API to a programming language . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
B2 . .
. . Transport Handles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
B3
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .*.
B4 . . Transport Mapping Codes
Transport Connection Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
B5 . .
B6 . . RDA/API functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .~.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
B7 . . RDA/API function invocation
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .*.*. 78
B8 . . RDA/API function Parameters
Contents v
0 ISO/IEC
. .*****.*****.******.***.*****~*.***.~.~~.~*~*.***.***.******.*****.*.*
Annex C Mapping of SQLKLI
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .*.
Cl . . SQLDisconnect
c2 . . SQLEndTran . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
c3 . . SQLSetConnectAttr, SQLSetStmtAttr and SQLSetEnvAttr
Statement> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
c4 . . Annex D RDA Location Server .**b***.***.**.***.****.**.*.*.*.*.**.************.****.***.*****.********.*.*****.*.*.*.*.**.*.*.~
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89
Dl . . RDA Location Server name and Schema
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
D.2. Server Location Table
******.***.**.*.*.****.*******.******.**********.*.*~******.*.*~*.*.****.*.***.**********.*.**.
Annex E RDA Support Server
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .*.
El . . RDA Support Server name and Schema
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
E2 . . Server Information Table
Request Log Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
E3 . .
****.********.***.***.**.*.**********.**.
Annex I?’ RDA Operations and Protocol in ASN.1 notation
.****.*.****.*.*******.*.*.*****.*****.*.*.***.*.*****.*******.*.**.***.*.*
Annex G‘ Encoding of Multiple Rows
vi Remote Database Access for SQL (RDABQL)

0 ISO/IEC
Tables
.............................................................................................
Table l-Codes used to identify the protocol
................................................................................. 24
Table 2-Codes used to identify the protocol version
.............................................................................
Table 3-Codes used to identify an RDA message type
...................................................................................
Table 4-Extension to Table 14 of ISO/IEC 9075-3
......................................................................................................
Table 5-Codes used for attribute types
...................................................................
Table 6-Codes used for RDA defined Connection Attributes
.....................................................................................................................
Table 7-Prohibited attributes
...................................................................................
Table 8-Extension to Table 19 of ISO/IEC 9075-3
............................................................................................................
Table 9-Values of Statement Ident
............................................................... 58
Table 1 l-RDADescriptorEntries required for SQL Data Types
........................................
Table 13-SQLSTATE class and subclass values for RDA-specific conditions
............................................
Table 14RDAResponse Parameter settings for RDA generated conditions
...................................................................................
Table 15-Codes used to identify TCP/IP encoding
...................................................................................................................
Table 1 o-Transport Mappings
.........................................................................................................
Table 17-Transport Mapping Codes
...........................................
Table C.l-RDA Operations invoked when evaluating an SQL/CLI function
Tables vii
0 ISO/IEC
ISO/IEC 9579: 1999 (E)
Figures
................................................................................................ 9
Figure l-RDA model of SQL-environment
......................................................................................
Figure 2-Model of the RDA-client environment.
......................................................................................
Figure 3-Model of the RDA server environment
viii Remote Database Access for SQL (RDABQL)

0 ISO/IEC
Foreword
ISO (the International Organization for Standardization) and IEC (the International Electrotechnical
Commission) form the specialized System for worldwide standardization. National bodies that are
members of ISO or IEC participate in the development of International Standards through technical
committees established by the respective organization to deal with particular fields of technical activity.
ISO and IEC technical committees collaborate in fields of mutual interest. Other international
organizations, govemmental and non-govemmental, in liaison with ISO and IEC, also take part in the
work.
In the field of information technology, ISO and IEC have established a joint technical committee,
ISO/IEC JTC 1. Draft International Standards adopted by the joint technical committee are circulated to
national bodies for voting. Publication as an International Standard requires approval by at least 75 %
of the national bodies casting a vote.
International Standard ISO/IEC 9579 was prepared by Joint Technical Committee ISO/IEC JTC 1,
Information technology, Subcommittee SC 32, Data management Services.
This edition cancels and replaces ISO/IEC 95794 : 1993, ISO/IEC 9579-2: 1988 and
ISO/IEC 9579-3: 1996, which have been technically revised.
Annexes A to E form an integral part of this International Standard. Annexes F and G are for
information only.
Foreword
0 ISO/IEC
ISO/IEC 9579: 1999 (E)
Introduction
Remote Database Access for SQL (RDA/SQL) International Standard is a member of a set of
International Standards produced to facilitate the interworking of Computer Systems. This International
Standard conforms to the model defined in ISO/IEC 10032, Information technology - Reference Model
of Data Management.
Remote Database Access for SQL tan be used to provide remote data access to a database management
System conforming to ISO/IEC 9075 (Database Language SQL).
The goal of Remote Database Access for SQL is to allow, with a minimum of technical agreement
outside this International Standard, the interconnection of applications and database Systems:
-
from different manufacturers,
under different managements,
-
of different levels of complexity,
exploiting different technologies.
An application may itself be a database System and therefore this International Standard tan be used to
support multi-database System interworking.
x Remote Database Access for SQL (RDABQL)

INTERNATIONAL STANDARD 0 ISO/IEC
ISO/IEC 9579: 1999 (E)
Information technology - Remote Database Access for SQL
1 Scope
This International Standard, Remote Database Access for SQL @DA), 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
infrastructures TCP/IP and Transport Layer Security (TLS).
This International Standard relies upon the facilities provided by ISO/IEC 9075 (SQL) and
ISO/IEC 9075-3 (SQLKLI).
Normative annexes provide:
-
a Conformance Proforma,
-
an optional language independent Application Programming Interface defined in the notational
conventions of ISO/IEC 9075-3 (SQLKLI) for invoking RDA Operations,
-
an optional mapping of ISO/IEC 9075-3 (SQL/CLI) functions to RDA Operations,
- definitions of optional SQL-Seivers, the RDA Location Server and the RDA Support Server, to
facilitate interoperation and data distribution in a heterogeneous environment.
Informative annexes provide:
-
an ASN.l 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 does not define:
-
algorithms for query decomposition or for the combining of results in a distributed database
environment,
-
recovery mechanisms in the event that transaction Co-Ordination fails.
Scope 1
0 ISO/IEC
2 Normative References
The following Standards contain provisions, which through reference in this text constitute provisions of
this International Standard. At the time of publication, the editions indicated were valid. All Standards
are subject to revision, and Parties to agreements based on this International Standard are encouraged to
Members of
investigate the possibility of applying the most recent editions of the Standards listed below.
ISO and IEC maintain registers of currently valid International Standards.
2.1 International Standards
Information technology - Abstract Syntax Notation One (ASN. 1): Specification
ISO/IEC 8824- 1: 1995
of basic notation
SpeciJication of Basic
ISO/IEC 8825-1: 1995 Information technology - ASN. 1 encoding rules:
Encoding Rules (BE), Canonicul Encoding Rules (CER) and Distinguished
Encoding Rules (DER)
Specification of Packed
ISO/IEC 8825-2: 1996 Information technology - ASN. 1 encoding rules:
Encoding Rules (PER)
ISO/IEC Information technology - Database Languages SQL
9075: 1992
ISO/IEC 9075-3: 1995 Information technology - Database Languages SQL - Part 3: Cal1 Level
Interface
ISO/IEC Information technology - Database Languages SQL - Part 4: Persistent Stored
9075-4: 1996
Modules
ISO/IEC Information technology - Reference Model of Data Management
10032: 1995
ISO/IEC 106460 1: 1993 Information technology - Universal Multiple-Octet Coded Character Set (UCS)
- Part 1: Architecture and Basic Multilingual Plane
l l
m fl -mY
2.2
Internet Engmeermg I am E‘orce
RFC 791 Internet Protocol
RFC 793 Transmission Control Protocol
RFC 819 The Domain Naming Convention for Internet User Applications
RFC 1122 Requirements for Internet Hosts - Communication Layers
RFC 1123 Requirements for Internet Hosts - Application and Support
RIT 2246 The TLS Protocol
Internet Engineering Task Forte Standards may be obtained in electronie form from the InterNIC
Directory and Database Services at http://www. internic. net and ftp:/ytp. internic. net.
2 Remote Database Access for SQL (RDA/SQL)

ISO/IEC 9579: 1999 (E) 0 ISO/IEC
2.3 Institute of Electrical and Electronics Engineers
2.3 Institute of Electrical and Electronics Engineers
IEEE 754-1985 Standard for Binary Floating-Point Arithmetic
Institute of Electrical and Electronie Engineers (IEEE) Standards may be obtained from ZEEE Customer
Service, 445 Hoes Lane, P. 0. Box 1331, Piscataway, NJ 08855-1331, USA or ordered electronically from
http://www. ieee. org.
Normative References 3
0 ISO/IEC
ISO/IEC 9579: 1999 (E)
3.1 Interoperability between implernentations
3 Interoperability
This clause defines the compatibility of RDA-client or RDA-server implernentations of the Operations
and Protocol defined by this edition of this International Standard with RDA-server or RDA-client
implernentations respectively of the Operations and Protocol defined by this and other editions of this
International Standard.
3.1 Interoperability between implernentations
An RDA-client or RDA-server implementation that conforms to this International Standard will
interoperate with any other RDA-server or RDA-client that conforrns to this International Standard
provided that the implernentations use the Same Transport Mapping.
Where protected access is required, the RDA-client and RDA-server need to share common
authentication mechanisms to inter-operate.
NOTE 1 - There are circumstances under which the RDA Protocol and RDA Operations defined by
this International Standard require that RDA Messages between interoperating implernentations are
rejected. These circumstances include the failure to satisfy authentication requirements and the use by one
implementation of an encoding that is not supported by the other (the Default Encoding is always
supported).
3.2 Interoperability with conforming Edition 2 implernentations
The second edition of this International Standard published in 1997 maps the Service and Protocol to an
OSI transport provider. This third edition of this International Standard maps the RDA Protocol to a
TCIVIP transport provider. Edition 2 implernentations tan therefore co-exist with edition 3
impl~ementations but cannot directly interoperate.
3.3 Interoperability with future editions
Features have been included in this version of the Protocol to permit server implernentations to detect
which version of the protocol a client has implemented and to behave appropriately.
Future editions of this International Standard will be compatible with this edition to the extent that:
.-
RDA Operations and Protocol defined by this edition will be retained in future editions using the
same encodings.
- Changes to the Operations, Protocols and encodings in future editions will be extensions that are
recognised by implernentations of this edition and discarded after raising an exception.
4 Remote Database Access for SQL (RDA/SQL)

ISO/IEC 9579: 1999 (E)
0 ISO/IEC
4.1 Definitions
4 Definitions, Conventions and Notations
4.1 Definitions
ISO/IEC 9075 (SQL) and
For the purposes of this International Standard, the definitions given in
ISO/IEC 9075-3 (SQLKLI) and the following definitions apply.
-
The following terms are defined in RFC 79 1, RFC 793, RFC 8 19, RFC 1122, RFC 1123:
i) IP Address,
ii) Local Socket,
iii) Foreign Socket,
iv) Port Number,
v) Push.
The following term is defined in ISO/IEC 10032:
Distribution Controller.
In addition, the following definitions apply:
a protocol element as defined by this International Standard exchanged between an
RDA Message:
RDA-client and an RDA-server.
a facility that is accessible remotely provided by an RDA-server, together with the
RDA Operation:
means of invoking the facility through a protocol, the encoding of Parameters that influence or result
from an invocation of the facility, and rules governing the invocation of the facility.
RDA Programming Interface: a language independent Application Programming Interface defined in
the notational conventions of ISO/IEC 9075-3 (SQWCLI) for invoking RDA Operations.
RDA Protocol: the set of permissible exchanges of requests and responses between an RDA-client and
an RDA-server, together with the encoding of the exchange, and rules governing the exchange.
Definitions, Conventions and Notations

ISO/IEC 9579: 1999 (E) 0 ISOKIEC
4.2 Conventions
4.2 Conventions
4.2.1 Convention for Figures
The convention used for figures is that defined in t
...