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

The international community has decided to make this standard available only in the English language version. It has been adopted as a National Standard of Canada on this basis. This National Standard of Canada is equivalent to International Standard ISO/IEC 8348:1993. 1.1 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 Systems 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 Language 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.