BS ISO/IEC 9579/2 : 1998

1 GENERAL
    1.1 Scope
    1.2 Normative references
    1.3 Compatibility
          1.3.1 SQL Standards Supported
          1.3.2 Upward Compatibility
    1.4 Definitions
          1.4.1 Terms defined in ISO/IEC 9075 (Database
                  Language SQL)
          1.4.2 Terms defined in this part of ISO/IEC 9579
                  1.4.2.1 SQL database resource
                  1.4.2.2 RDA SQL statement
    1.5 Abbreviations
    1.6 Conventions
2 MODEL
    2.1 The RDA SQL Specialization Service
          2.1.1 Mapping to the general model of the RDA
                  Service
          2.1.2 Mapping to the Concepts of Database
                  Language SQL
3 SERVICE
    3.1 The RDA SQL Specialization Service
          3.1.1 RDA Dialogue Management services
                  3.1.1.1 RDA Dialogue Initialization
                           functional unit
                           3.1.1.1.1 R-Initialize Service
                  3.1.1.2 RDA Dialogue Termination functional
                           unit
                           3.1.1.2.1 R-Terminate Service
          3.1.2 RDA Transaction management services
                  3.1.2.1 RDA Transaction Management
                           functional unit
                           3.1.2.1.1 R-Begin Transaction
                                      Service
                           3.1.2.1.2 R-Commit Service
                           3.1.2.1.3 R-Rollback Service
          3.1.3 RDA Control Services
                  3.1.3.1 Cancel functional unit
                           3.1.3.1.1 R-Cancel Service
                  3.1.3.2 Status functional units
                           3.1.3.2.1 R-Status Service
          3.1.4 Resource Handling services
                  3.1.4.1 Resource Handling functional unit
                           3.1.4.1.1 R-Open Service
                           3.1.4.1.2 R-Close Service
          3.1.5 Database Language Services
                  3.1.5.1 Immediate Execution DBL functional
                           unit
                           3.1.5.1.1 R-ExecuteDBL Service
                  3.1.5.2 Stored Execution DBL functional
                           unit
                           3.1.5.2.1 R-DefineDBL Service
                           3.1.5.2.2 R-InvokeDBL Service
                           3.1.5.2.3 R-DropDBLService
          3.1.6 SQL statements, arguments and results
                  3.1.6.1 sQLDBLStatement
                  3.1.6.2 sQLDBLArgumentSpecification and
                           sQLDBLResultSpecification
                  3.1.6.3 sQLDBLArgumentValues and
                           sQLDBLResultValues
                  3.1.6.4 Referencing to parameters
    3.2 Sequencing rules
                  3.2.1.1 RDA client sequencing rules
          3.2.2 RDA Server Sequencing Rules
4 PROTOCOL
    4.1 THE RDA SQL Specialization client execution rules
          4.1.1 RDA SQL Specialization dialogue-state model
                  4.1.1.1 SQL Transaction Entity
          4.1.2 General client execution rules
                  4.1.2.1 Generation of the SQL transaction
                           entity
                  4.1.2.2 Execution of an SQL-statement
          4.1.3
          4.1.4
          4.1.5
          4.1.6
          4.1.7
    4.2 The RDA SQL Specialization server execution rules
          4.2.1 RDA SQL Specialization dialogue-state model
                  4.2.1.1 RDA dialogue entity
                  4.2.1.2 Opened data resource entity
                  4.2.1.3 Defined DBL Entity
                  4.2.1.4 RDA operation entity
          4.2.2 General server execution rules
          4.2.3 RDA Dialogue Management services
                  4.2.3.1 RDA Dialogue initialization
                           functional unit
                           4.2.3.1.1 R-Initialize Service
                  4.2.3.2 RDA Dialogue Termination functional
                           unit
                           4.2.3.2.1 R-Terminate Service
          4.2.4 RDA Transaction Management services
                  4.2.4.1 RDA Transaction Management functional
                           unit
                           4.2.4.1.1 R-Begin Transaction
                                      Service
                           4.2.4.1.2 R-Commit service
                           4.2.4.1.3 R-Rollback Service
          4.2.5 RDA Control services
                  4.2.5.1 Cancel functional unit
                           4.2.5.1.1 R-Cancel Service
                  4.2.5.2 Status functional unit
                           4.2.5.2.1 R-Status Service
          4.2.6 Resource Handling services
                  4.2.6.1 Resource Handling functional unit
                           4.2.6.1.1 R-Open Service
                           4.2.6.1.2 R-Close Service
          4.2.7 Database Language services
                  4.2.7.1 Immediate Execution DBL functional
                           unit
                           4.2.7.1.1 R-ExecuteDBL service
                  4.2.7.2 Stored Execution DBL functional
                           unit
                           4.2.7.2.1 R-define DBL Service
                           4.2.7.2.2 R-InvokeDBL Service
                           4.2.7.2.3 R-DropDBL Service
    4.3 Structure and Encoding of RDA SQL APDUs
          4.3.1 Abstract Syntax Name
          4.3.2 ASN.1 module for RDA SQL Specialization ASE
    4.4 Conformance
          4.4.1 Static conformance
          4.4.2 Dynamic Conformance
5 THE RDA SQL SPECIALIZATION APPLICATION-CONTEXTS
    5.1 The RDA SQL Basic application-context
          5.1.1 RDA SQL Basic application-context
          5.1.2 Additional constraints on the RDA SQL ASE
                  datatypes
          5.1.3 Additional sequencing rules
          5.1.4 Additional conformance requirements
                  5.1.4.1 Static conformance
                  5.1.4.2 Dynamic conformance
    5.2 The RDA SQL TP application context
          5.2.1 RDA SQL TP application-context object
                  identifier
          5.2.2 Additional constraints on the RDA SQL ASE
                  datatypes
          5.2.3 Additional sequencing rules
          5.2.4 Additional conformance requirements
                  5.2.4.1 Static conformance
                  5.2.4.2 Dynamic conformance
Annex A (informative) Encoding of Multiple Rows
Figures
1 Usage of Embedded SQL Variables
Tables
1 R-Initialise SQL Specific Service Parameters
2 R-Cancel SQL Specific Service Parameters
3 R-Status SQL Specific Service Parameters
4 R-Open SQL Specific Service Parameters
5 R-Close SQL Specific Service Parameters
6 R-ExecuteDBL SQL Specific Service Parameters
7 R-Define DBL SQL Specific Service Parameters
8 R-InvokeDBL SQL Specific Service Parameters
9 sQLDBLStatement
10 sQLDVLArgumentSpecification and sQLDBLResultSpecification
11 sQLDBLArgumentValues and sQLDBLResultValues
12 R-ExecuteDBL use of SQL argument and result parameters
13 R-DefineDBL use of SQL argument and result parameters
14 R-InvokeDBL use of SQL argument and result parameters

Specifies the functionality of a database server within a distributed open systems environment and specifies the communication services and protocol for accessing its capabilities. Coverage includes: the RDA SQL Specialization Service Model; R-Begin Transaction Service; Database Language Services; Opened Data Resource Entity; RDA server sequencing rules.