ISO/IEC 9075-3:2016 情報技術—データベース言語— SQL —パート3：コールレベルインターフェイス（SQL / CLI） | ページ 2

3.1.1 で提供される定義3

このドキュメントでは、次の定義が適用されます。

3.2.1 ルーチン定義の仕様

このドキュメントのルーチンは、次の観点から指定されています。

• 機能 : ルーチンの目的の短いステートメント。
• 定義 : ルーチンの名前と、その各パラメーターの名前、モード、およびデータ型。
• 一般規則 : ルーチンの実行時効果の仕様。ルーチンの効果を指定するために複数の一般規則が使用される場合、要求される効果は、最初の一般規則から始めて、変更を指定または暗示する規則が適用されるまで番号順に規則を適用することによって得られる効果です。規則の適用の順序または終了。適用される特定の規則によって特に指定または暗示されている場合を除き、一般規則の適用は、一連の最後の規則が適用された時点で終了します。

Foreword

ISO (the International Organization for Standardization) and IEC (the International Electrotechnical Commission) form the specialized system for worldwide standardization. National bodies that are members of ISO or IEC participate in the development of International Standards through technical committees established by the respective organization to deal with particular fields of technical activity. ISO and IEC technical committees collaborate in fields of mutual interest. Other international organizations, governmental and non-governmental, in liaison with ISO and IEC, also take part in the work. In the field of information technology, ISO and IEC have established a joint technical committee, ISO/IEC JTC 1.

The procedures used to develop this document and those intended for its further maintenance are described in the ISO/IEC Directives, 1. In particular the different approval criteria needed for the different types of document should be noted. This document was drafted in accordance with the editorial rules of the ISO/IEC Directives, 2 (see www.iso.org/directives ).

Attention is drawn to the possibility that some of the elements of this document may be the subject of patent rights. ISO and IEC shall not be held responsible for identifying any or all such patent rights. Details of any patent rights identified during the development of the document will be in the Introduction and/or on the ISO list of patent declarations received (see www.iso.org/patents ).

Any trade name used in this document is information given for the convenience of users and does not constitute an endorsement.

For an explanation on the meaning of ISO specific terms and expressions related to conformity assessment, as well as information about ISO's adherence to the World Trade Organization (WTO) principles in the Technical Barriers to Trade (TBT) see the following URL: www.iso.org/iso/foreword.html .

The committee responsible for this document is ISO/IEC JTC 1, Information technology, SC 32, Data management and interchange.

This fifth edition of ISO/IEC 9075-3 cancels and replaces the fourth edition (ISO/IEC 9075-3:2008), which has been technically revised.

A list of all parts in the ISO/IEC 9075 series, published under the general title Information technology — Database languages — SQL: , can be found on the ISO website.

Introduction

The organization of this part of ISO/IEC 9075 is as follows:

• 1) Clause 1, “Scope”, specifies the scope of this part of ISO/IEC 9075.
• 2) Clause 2, “Normative references”, identifies additional standards that, through reference in this part of ISO/IEC 9075, constitute provisions of this part of ISO/IEC 9075.
• 3) Clause 3, “Definitions, notations, and conventions”, defines the notations and conventions used in this part of ISO/IEC 9075.
• 4) Clause 4, “Concepts”, presents concepts used in the definition of the Call-Level Interface.
• 5) Clause 5, “Call-Level Interface specifications”, defines facilities for using SQL through a Call-Level Interface.
• 6) Clause 6, “SQL/CLI routines”, defines each of the routines that comprise the Call-Level Interface.
• 7) Clause 7, “Additional data manipulation rules”, defines additional rules for data manipulation.
• 8) Clause 8, “Dynamic SQL”, defines the SQL dynamic statements.
• 9) Clause 9, “Definition Schema”, specifies extensions to the Definition Schema required for support of the Call-Level Interface.
• 10) Clause 10, “Conformance”, defines the criteria for conformance to this part of ISO/IEC 9075.
• 11) Annex A, “SQL Conformance Summary”, is an informative Annex. It summarizes the conformance requirements of the SQL language.
• 12) Annex B, “Implementation-defined elements”, is an informative Annex. It lists those features for which the body of this part of ISO/IEC 9075 states that the syntax, the meaning, the returned results, the effect on SQL-data and/or schemas, or any other behavior is partly or wholly implementation-defined.
• 13) Annex C, “Implementation-dependent elements”, is an informative Annex. It lists those features for which the body of this part of ISO/IEC 9075 states that the syntax, the meaning, the returned results, the effect on SQL-data and/or schemas, or any other behavior is partly or wholly implementation-dependent.
• 14) Annex D, “Deprecated features”, is an informative Annex. It lists features that the responsible Technical Committee intend will not appear in a future revised version of this part of ISO/IEC 9075.
• 15) Annex E, “Incompatibilities with ISO/IEC 9075:2011 and 9075:2008”, is an informative Annex. It lists incompatibilities with the previous version of this part of ISO/IEC 9075.
• 16) Annex F, “SQL feature taxonomy”, is an informative Annex. It identifies features of the SQL language specified in this part of ISO/IEC 9075 by an identifier and a short descriptive name. This taxonomy is used to specify conformance.
• 17) Annex G, “Defect reports not addressed in this edition of this part of ISO/IEC 9075”, is an informative Annex. It describes the Defect Reports that were known at the time of publication of this part of this International Standard. Each of these problems is a problem carried forward from the previous edition of ISO/IEC 9075. No new problems have been created in the drafting of this edition of this International Standard.
• 18) Annex H, “Typical header files”, is an informative Annex. It provides examples of typical definition files for application programs using the SQL Call-Level Interface.
• 19) Annex I, “Sample C programs”, is an informative Annex. It provides examples of using the SQL Call-Level Interface in the C programming language.

In the text of this part of ISO/IEC 9075, Clauses and Annexes begin new odd-numbered pages, and in Clause 5, “Call-Level Interface specifications”, through Clause 10, “Conformance”, Subclauses begin new pages. Any resulting blank space is not significant.

1 Scope

This part of ISO/IEC 9075 defines the structures and procedures that can be used to execute statements of the database language SQL from within an application written in a programming language in such a way that procedures used are independent of the SQL statements to be executed.

2 Normative references

The following referenced documents are indispensable for the application of this document. For dated references, only the edition cited applies. For undated references, the latest edition of the referenced document (including any amendments) applies.

2.1 ISO and IEC standards

3 Definitions, notations, and conventions

This Clause modifies Clause 3, “Definitions, notations, and conventions”, in ISO/IEC 9075-2.

3.1 Definitions

This Subclause modifies Subclause 3.1, “Definitions”, in ISO/IEC 9075-2.

3.2 Conventions

This Subclause modifies Subclause 3.3, “Conventions”, in ISO/IEC 9075-2.