©January 1998, The Open Group All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording or otherwise, without the prior permission of the copyright owners.

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

Product Standard

NAME

Relational Database

LABEL FOR LOGO

No label.

DESCRIPTION

This Product Standard provides application program access to a relational database via the Structured Query Language (SQL) embedded in C and/or COBOL. X/Open SQL includes dynamic SQL, and is aligned with ISO/IEC 9075:1992 (SQL).¹ It also includes specifications which allow portability of applications to distributed environments.

CONFORMANCE REQUIREMENTS

Human-Computer Interface

Not applicable.

Portability Interface

The SQL Specification,² with any of the following:

• Support for SQL embedded in both ISO and X/Open Common Usage C languages (Embedded C Language support)

• Support for SQL embedded in COBOL language (Embedded COBOL support)

• Embedded C Language support and embedded COBOL Language support

Programming Language Environment

SQL language as defined in the SQL Specification embedded in C and/or COBOL. C language and/or COBOL source programs invoking the services of this Product Standard must be supported by the registered product.

Interoperability

• Data Interchange Formats

  None.

• Communications Interfaces and Protocols

  None.

Products conforming to this Product Standard may optionally support the XA interface for integration into a TP system as defined in the XA Specification³, Resource Manager conformance requirements in a C Language environment.

OPERATIONAL ENVIRONMENT

Not applicable.

PORTABILITY ENVIRONMENT

XPG3 Internationalized System Calls and Libraries, Internationalized System Calls and Libraries, Internationalized System Calls and Libraries Extended, or Internationalized System Calls and Libraries Extended V2 (except for XA).

OVERRIDING STANDARDS

ISO/IEC 9075:1992 (SQL).

INDICATORS OF COMPLIANCE

A Test Report from a currently authorized release of the NIST/SQL Test Suite Release 5.

MIGRATION

Largely compatible with the XPG3 SQL Product Standard. The differences are identified in Section 1.3, This Edition, of the SQL Specification.

Any comments relating to the material contained in this document may be submitted to The Open Group at:

The Open Group
Apex Plaza
Forbury Road
Reading
Berkshire, RG1 1AX
United Kingdom

OGSpecs@opengroup.org

Footnotes

1.

ISO/IEC 9075:1992, Information Technology - Database Language SQL (technically identical to ANSI standard X3.135-1992).

2.

CAE Specification, August 1992, Structured Query Language (SQL) (ISBN: 1-872630-58-8, C201).

3.

CAE Specification, December 1991, Distributed Transaction Processing: The XA Specification (ISBN: 1-872630-24-3, C193).