ISO/IEC 9075-3:2016/Cor 1:2022

Overview

ISO/IEC 9075-3:2016/Cor 1:2022 is a Technical Corrigendum to the international standard ISO/IEC 9075-3:2016, part of the ISO/IEC 9075 series focusing on database languages and SQL. This corrigendum addresses specific clarifications and corrections related to the Call-Level Interface (SQL/CLI), which defines the interface between applications and SQL databases at the call level.

Prepared by the Joint Technical Committee ISO/IEC JTC 1/SC 32 on Data Management and Interchange, this corrigendum refines technical details around SQL/CLI features, helping ensure better interoperability, accuracy in feature identification, and compliance with SQL standards.

Published in June 2022, this document is essential for developers, database administrators, and system integrators working with SQL call-level interfaces.

Key Topics

• Corrected Feature Identification
  The corrigendum refines how features are identified within the Call-Level Interface. For example, it clarifies the handling of multiple server transactions (feature C008) to properly raise exceptions when unsupported.

• Improved Exception Handling
  Updated rules specify that if an SQL transaction is already active on a connection and multiple server transactions are not supported, an exception must be raised. This ensures robustness and predictable behavior in SQL client-server interactions.

• SQL/CLI Routine Updates
  Specific SQL/CLI routines such as Connect and GetFeatureInfo have been revised for clarity. For instance, the correction updates the SQL query used by GetFeatureInfo to accurately retrieve feature support information from the INFORMATION_SCHEMA.SQL_FEATURES table.

• Conformance Rules Summary
  The corrigendum expands the Annex summarizing conformance rules, emphasizing features specified outside the usual conformity framework and listing relevant subclauses for better reference.

Applications

• Database Middleware Development
  Middleware solutions utilizing SQL/CLI rely on clear standards for connection handling and feature support queries. This corrigendum supports the development of robust middleware by defining clear rules for multiple transactions and error handling.

• SQL Client Software
  Developers of SQL client software benefit from updated Connect and GetFeatureInfo routines, enabling more accurate feature negotiation and connection management conforming to international standards.

• Interoperability in Multi-Database Environments
  Enterprises integrating multiple database systems can reduce errors related to transaction management and feature support by implementing these clarified standards, improving system reliability.

• Database Testing and Compliance
  Testing tools assessing SQL/CLI compliance use these corrections to create accurate conformance tests, ensuring database clients meet international expectations for feature support and error handling.

Related Standards

• ISO/IEC 9075 Series
  The ISO/IEC 9075 family covers SQL standards broadly, including parts for the language definition, persistent stored modules, call-level interface, and others. This corrigendum applies specifically to Part 3 on SQL/CLI.

• ISO/IEC 9075-3:2016
  The original edition that this corrigendum updates. It defines the baseline specifications for the SQL Call-Level Interface.

• ISO/IEC JTC 1/SC 32 Standards
  Other related data management and interchange standards developed by the same subcommittee may reference or interact with this corrigendum in contexts involving SQL and data interchange.

This technical corrigendum is a key resource to maintain the integrity and clarity of SQL/CLI implementation, ensuring industry-wide consistency in database connectivity and feature support. Emphasizing SQL standards compliance, transaction management, and feature querying accuracy, it supports developers and organizations in creating stable, interoperable database systems.