• There are no items in your cart

BS ISO/IEC 9579/2 : 1998

Superseded

Superseded

A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.

View Superseded by

INFORMATION TECHNOLOGY - OPEN SYSTEMS INTERCONNECTION - REMOTE DATABASE ACCESS - SQL SPECIALIZATION

Available format(s)

Hardcopy , PDF

Superseded date

15-08-2001

Language(s)

English

Published date

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

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.

Committee
IST/21
DocumentType
Standard
Pages
74
PublisherName
British Standards Institution
Status
Superseded
SupersededBy
Supersedes

Standards Relationship
ISO/IEC 9579-2:1998 Identical

ISO/IEC 8824:1990 Information technology — Open Systems Interconnection — Specification of Abstract Syntax Notation One (ASN.1)
ISO/IEC 9075:1992 Information technology — Database languages — SQL
ISO/IEC 8825:1990 Information technology — Open Systems Interconnection — Specification of Basic Encoding Rules for Abstract Syntax Notation One (ASN.1)
ISO/IEC 9075-3:2016 Information technology — Database languages — SQL — Part 3: Call-Level Interface (SQL/CLI)
ISO/IEC 9075-4:2016 Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM)

View more information
€305.95
Excluding VAT

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.