Skip to content
CSA Store
  • CSA Group
  • CSA OnDemandâ„¢
  • CSA Communities
  • Contact Us
  • Catalogue
    • Browse By Subject Area

      • Electrical
      • Fuels & Transportation
      • Petroleum & Natural Gas
      • Environment & Natural Resources
      • Construction & Infrastructure
      • Mechanical & Industrial Equipment
      • Nuclear
      • Health Care and Well-being
      • Worker & Public Safety
      • Management Systems
    • Browse By Publisher

      • ASME
      • ASTM
      • CSA Group
      • ESA
      • IEC
      • ISO
      • NRC
      • ORNAC
      • TSSA
    • ICS Catalogue

      • Browse by International Classification of Standards (ICS Codes)
  • Subscription
    • Browse By Subject Area

      • Electrical
      • Fuels & Transportation
      • Petroleum & Natural Gas
      • Environment & Natural Resources
      • Construction & Infrastructure
      • Mechanical & Industrial Equipment
      • Nuclear
      • Health Care and Well-being
      • Worker & Public Safety
      • Management Systems
    • CSA Subscriptions

      • Overview
      • Collections
    • ICS Catalogue

      • Browse by International Classification of Standards (ICS Codes)
  • Services
Cart Icon0
×
Login / Register
English / CAD

Language

en

fr

Currency

CAD

USD

  • CSA Group
  • CSA OnDemandâ„¢
  • CSA Communities
  • Contact Us
Wishlist

Catalogue

  • Browse By Subject Area

    • Electrical
    • Fuels & Transportation
    • Petroleum & Natural Gas
    • Environment & Natural Resources
    • Construction & Infrastructure
    • Mechanical & Industrial Equipment
    • Nuclear
    • Health Care and Well-being
    • Worker & Public Safety
    • Management Systems
  • Browse By Publisher

    • ASME
    • ASTM
    • CSA Group
    • ESA
    • IEC
    • ISO
    • NRC
    • ORNAC
    • TSSA
  • ICS Catalogue

    • Browse by International Classification of Standards (ICS Codes)

Subscription

  • Browse By Subject Area

    • Electrical
    • Fuels & Transportation
    • Petroleum & Natural Gas
    • Environment & Natural Resources
    • Construction & Infrastructure
    • Mechanical & Industrial Equipment
    • Nuclear
    • Health Care and Well-being
    • Worker & Public Safety
    • Management Systems
  • CSA Subscriptions

    • Overview
    • Collections
  • ICS Catalogue

    • Browse by International Classification of Standards (ICS Codes)

Services

Menu toggle Icon
Login / Register
English / CAD

Language

en

fr

Currency

CAD

USD

Wishlist Cart (
)

Search Section

    • Home
    • CAN/CSA-ISO/IEC 9579-2-95 (R2000)

    Codes & Standards - Subscribe

    CAN/CSA-ISO/IEC 9579-2-95 (R2000)

    Information Technology - Open Systems Interconnection - Remote Database Access - Part 2: SQL Specialization (Adopted ISO/IEC 9579-2:1993)
    SKU: 2703007 Published by CSA Group Publication Year 1995 Reaffirmed in 2000 Withdrawn

    Product Details

    • Preface/Scope
    • Items Included
    Scope

    This part of ISO/IEC 9579 specifies the functionality of a database server within a distributed open systems environment and specifies the communication service and protocol for accessing its capabilities. The communications capabilities are positioned in the Application Layer of the Reference Model of Open Sy stems Interconnection (OSI).

    This part of ISO/IEC 9579 complements ISO/IEC 9579-1 (RDA Generic) in order that the two parts together:

    (a) define the capabilities of an RDA SQL database server supporting dialogues with clients.
    (b) define a model of dialogues between the RDA SQL database server and remote users.
    (c) define a model of a dialogue between an RDA client and an RDA server.
    (d) define an abstract service for the RDA SQL ASE, which models the communications facilities supporting interaction between the RDA client and RDA server.
    (e) define the RDA SQL ASE protocol to support the RDA SQL Service.
    (f) define the characteristics of application-contexts which include the RDA SQL ASE.
    (g) define application-contexts that support remote database access using SQL:
     (1) RDA Basic application-context
     (2) RDA TP application-context

    This part of ISO/IEC 9579 does not specify individual implementations or products, nor does it constrain the implementation of entities and interfaces within a computer system.

    This part of ISO/IEC 9579 does not define a programmatic interface. The RDA server includes a database capability as defined in ISO/IEC 9075 (Database Language SQL).

    NOTES
    1  The RDA client may contain an SQL application program but there is no requirement that the RDA client shall be an application program written to the ISO/IEC 9075 (Database Lang uage SQL) application program interface.

    2  ISO/IEC 9075:1989, the former International Standard for Database Language SQL, has been replaced by ISO/IEC 9075:1992. Both the current and former standards contain conformance rules, and the RDA SQL Specialization allows an RDA client to specify the desired level of conformance which it expects the RDA Server to support. Throughout this part of ISO/IEC 9579, SQL refers to the language statements permitted by the appropriate standard at the requested level of conformance.
    Download a list of included items
    items 1 - of 1 result(s)
    View 20 | View 100

    CAN/CSA-ISO/IEC 9579-2-95 (R2000)

    Information Technology - Open Systems Interconnection - Remote Database Access - Part 2: SQL Specialization (Adopted ISO/IEC 9579-2:1993)

    Withdrawn
    English
    copyright imgRequest Copyright Permissions

    Subscribe

    Annual subscription keeps you up-to-date with the latest editions of standards and includes all supported languages and archive versions. 

    * Price is for up to 10 users. Select the number of users required on the cart page. Subscription must include a minimum of 10 standards or a collection to proceed to checkout.

    Includes annual access to:

           • Newest and previous editions in PDF format 
           • Revisions, updates and amendments 
           • All supported languages 

    Learn More

    PDF

    English, French

    Go to additional format options
    • FAQs
    • Contact Us
    • Email Product

    GST REG No R119441681
    QST REG No R1006017360

    Compare Formats

    Determine the subscription format that is right for you.

    Features CSA AdvantageTM CSA OnDemandTM
    Offline accessSelectedSelected
    Full-text searchSelectedSelected
    Create highlights and personal notesSelectedSelected
    Newest editions added automaticallySelectedSelected
    Includes all supported languages and archive versionsSelected
    My Files - create customized files by adding multiple clauses, tables or figures from the standard into your own personal File for quick referenceSelected
    Toggle between your files and the full standard to maintain contextSelected
    Instantly preview cross referenced material within the bookSelected
    Export personal notes to ExcelSelected
    Transfer notes and highlights when updates are availableSelected
    Adobe Reader PDF and browser compatible for iOS and AndroidSelected
    Web, Android, iOS CompatibleSelected

    Follow Us On Social Media

    Get Our Newsletter

    Get CSA Newsletter

    • About CSA Store
    • Subscription
    • Services
    • Catalogue
    • FAQ
    • Return Policy
    • FULFILLMENT DETAILS
    • EBOOK SUPPORT
    • Product Updates
    • Contact Us
    • CSA GROUP
    • CSA COMMUNITIES
    • CSA Update Service
    • About CSA Store
    • Subscription
    • Services
    • Catalogue
    • FAQ
    • Return Policy
    • FULFILLMENT DETAILS
    • EBOOK SUPPORT
    • Product Updates
    • Contact Us
    • CSA GROUP
    • CSA COMMUNITIES
    • CSA Update Service

    • General Terms and Conditions
    • Privacy Policy
    • Accessibility
    © 2022 Canadian Standards Association. All rights reserved
    logo close
    Privacy Preference Centre

    Please manage your cookie choices by switching the consent toggles on or off under the Purposes below.

    You may change your preference at any time as described in our Cookie Policy

    • Cookie Settings
    • List of Cookies
    close
      Cookies on CSA Group

      We use Cookies to create a secure and effective website experience for our customers. For more information about Cookies and how you can disable Cookies, visit our privacy policy page. Learn More

      Free Login/Registration Required

      View Access for this document is only available for viewers in Canada.

      A free user account is required to view this document.

      Login or Register