BS ISO/IEC 9579/2 : 1998
Superseded
A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.
A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.
Hardcopy , PDF
08-15-2001
English
01-01-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
Important note : All end users must be registered with an Account prior to user licenses being assigned.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.