HomeAbout Us A-Z IndexSearchInquiries RegisterLoginPress Shop
Conformance Statement

Product Standard: Relational Database

This form contains a series of questions that need to be answered. As you go about answering the questions, please keep the following things in mind:

Enter the name of the Organization that produced the implementation and the name of the author of the Conformance Statement.

Organization
Author


1. Relational Database

Product Information

Enter the product name, version/release number, and product supplier for each product required to meet the conformance requirements.

Product IdentificationVersion/Release NumberProduct Supplier
 
 
 
 
 

Environment Specification

Product registration applies to software products operating in a specific hardware or hardware/software environment.

A product may be registered in all members of a binary-compatible family of products on the basis of a single test report.

Answer the questions for each binary-compatible family. Alternately, provide the answers in the Appendix at the end of this document.

Testing Environment Binary-compatible Family Portability Environment Indicator of Compliance Compliance Details
Test Suite:
Test Report:
Test Suite:
Test Report:
Test Suite:
Test Report:
Test Suite:
Test Report:
Test Suite:
Test Report:

Temporary Waivers

Enter the waiver number and expiry date for each temporary waiver granted by The Open Group.

Waiver NumberExpiry Date


1.1 General Compliance Category

1.1.1 Host Languages

Question 1: For what host language(s) does your implementation provide bindings?

Response

Rationale

Reference


1.1.2 Transaction Processing XA Interface

Question 2: Does your implementation conform to the X/Open XA interface?

Response

Rationale

Reference


1.1.3 Support for Optional Features

Question 3: What is your implementation's level of support for the features labelled optional in X/Open SQL?

Response

Rationale

Reference


1.1.4 Character Set Support

Question 4: Does your implementation support multiple character sets?

Response

Rationale

Reference


1.2 Implementation-Specific Issues

1.2.1 Clients and Servers

Question 5: Does your implementation use a client-server structure?

Response

Rationale

Reference


1.2.2 Users of the Database

Question 6: How are user names associated with the database?

Response

Rationale

Reference


1.2.3 Arithmetic Results

Question 7: What attributes does your implementation use for the following?

Response

Rationale

Reference


Question 8: How are null values treated in the ORDER BY clause?

A null value is all non-null values.

Reference


1.2.4 Scope of Host Variable

Question 9: What is the scope of a host variable?

Response

Rationale

Reference


1.2.5 Uniqueness of Cursors

Question 10: Can two dynamic DECLARE CURSOR statements reference the same statement-identifier?

Response

Reference


1.2.6 Changes to Schema

Question 11: How does the implementation deal with the situation where the schema changes after a program has been compiled?

Response

Rationale

Reference


Question 12: How does the implementation resolve the situation where a schema and an SQL statement are inconsistent at compilation time or at execution time?

Response


1.2.7 Implementation Diagnostics

Question 13: What run-time diagnostics are defined by your implementation?

Response

Reference


1.2.8 Limits and Defaults

Question 14: What limits, if any, does your implementation place on the following?

Response


Question 15: Are there any other limits your implementation imposes on applications because of storage limitations specific to your implementation?

Response

Rationale

Reference


1.2.9 Restrictions on Names

Question 16: What reserved words, if any, does your implementation reserve in addition to those defined as reserved words in X/Open SQL?

Response


Question 17: Does the implementation reserve any part of the name space for procedure, function or variable names?

Response


Question 18: What is the scope of a base-table-identifier and viewed-table-identifier?

Response


Question 19: What is the relationship of the namespace of index-identifier and the namespace of table-identifier?

Each of index-identifier and table-identifier has a separate namespace. The index-identifier and table-identifier have the same namespace.


Question 20: Are keywords available for use as embedded host variables?

Response


Question 21: Does your implementation allow qualification by user name within table and index names in CREATE statements?

Response


Question 22: What is the maximum length of a user name that may be retrieved into a host variable?

Response

Rationale

Reference


1.2.10 Data Definition Statements in Transactions

Question 23: What are the transaction semantics of data definition statements and data manipulation statements?

Response


Question 24: How are transactions demarcated in your implementation?

Response

Rationale

Reference


1.2.11 Commitment of Transactions

Question 25: What happens when communication errors occur during execution of a COMMIT statement?

Response

Rationale

Reference


Question 26: What happens when a program ceases execution without ending an active transaction?

Response

Reference


1.2.12 Assignments

Question 27: What semantics for character string assignment does your implementation support?

Response

Rationale

Reference


1.2.13 DECLARE CURSOR

Question 28: When is a DECLARE CURSOR statement executed?

Response

Rationale

Reference


Question 29: Can multiple dynamic DECLARE CURSOR statements reference the same statement-identifier?

Response


1.2.14 Integrity Constraints

Question 30: Does your implementation defer the checking of uniqueness constraints during multi-row updates?

Response

Rationale

Reference


1.2.15 EXECUTE IMMEDIATE

Question 31: Does your implementation support the EXECUTE IMMEDIATE statement?

Response

Rationale

Reference


1.2.16 SELECT

Question 32: When is the * expression in a query-specification evaluated?

Response

Rationale


1.2.17 Variable-Length String Comparison

Question 33: How does your implementation compare variable-length strings?

Response

Rationale

Reference


1.3 Transaction Processing (XA) Interface

The remainder of this CSQ must be completed if, and only if, the answer to Question 2 is "Yes". The SQL product is the resource manager (RM) in the questions below; TM means the X/Open-compliant transaction manager.

1.3.1 Support for Dynamic Registration

Question 34: Does your implementation support dynamic registration?

Response

Rationale

Reference


1.3.2 Switch Structure

Question 35: What is the name of the structure the RM defines of type xa_switch_t?

Response


Question 36: What are the contents of this structure?

Response


Question 37: What are the forms of the information strings?

Response


Question 38: May the TM supply a null string in place of either information strings?

Response


Question 39: May several instances of the RM implementation operate from the same switch structure?

Response

Rationale

Reference


1.3.3 Linking Information

Question 40: What linking information is necessary for your implementation in the DTP environment?

Response


Question 41: What are the changes in your implementation's API in the DTP environment?

Response

Reference


1.3.4 Read-only Optimisation

Question 42: Does your implementation use the read-only optimisation?

Response

Rationale

Reference


1.3.5 Association Migration

Question 43: Does your implementation support association migration?

Response

Rationale

Reference


1.3.6 Branch Identification

Question 44: How does your implementation use the bqual component of the XID?

Response

Rationale

Reference


1.3.7 Asynchronous Calling Mode

Question 45: Does your implementation support the asynchronous calling mode?

Response

Rationale

Reference


1.3.8 Heuristics

Question 46: Does your implementation support heuristics?

Response

Rationale

Reference


1.4 Other Topics

Although X/Open SQL lists the following topic as implementation-defined, X/Open does not require further information in response to this questionnaire:

Whether a pre-compiler is used and how the task of processing SQL syntax is divided between the compiler and any pre-compiler. (Reference CAE Specification, Structured Query Language (SQL), Section 2.1.1, General Terms.)


2. Appendix

This appendix contains additional, explanatory material that was provided by the vendor.


Copyright © 
All rights reserved.


3. Change History

DateNameComment
New

 Copyright © 1998-2002 The Open Group. All Rights Reserved.

 OSF/1, Motif, UNIX, and the "X" device are registered trademarks in the U.S. and other countries, and IT DialTone and The Open Group are trademarks of The Open Group.


[ Home ] [ Testing Home ] [ Conformance Statement Library Home ] [ Search Conformance Statements ] [ Send Feedback ]