INTERNATIONAL ISO/IEC STANDARD 9075-3 Sixth edition 2023-06 Information technology - Database languages SQL - Part 3: Call-Level Interface (SQL/CLI) Reference number IEC ISO/IEC 9075-3:2023(E) OS1 @ IS0/IEC 2023 IS0/IEC 9075-3:2023(E) COPYRIGHT PROTECTED DOCUMENT @IS0/IEC2023 All rights reserved. Unless otherwise specified, or required in the context of its implementation, no part of this publication may be reproduced or utilized otherwise in any form or by any means, electronic or mechanical, including photocopying, or posting on or ISo's member body in the country of the requester. ISO copyright office CP 401 · Ch. de Blandonnet 8 CH-1214 Vernier, Geneva Phone: +41 22 749 01 11 Email: [email protected] Website: www.iso.org Published in Switzerland i @ IS0/IEC 2023 - All rights reserved IS0/IEC 9075-3:20@(E) Contents Page Foreword.. .ix Introduction. xi 1 Scope. 2 Normative references.. 3 Terms and definitions. 4 Concepts. 4.1 Notations and conventions. . 4.1.1 Notations. 4.1.2 Specification of routine definitions. . 4.2 Introduction to SQL/CLI. . 4.3 Return codes. .. 4.4 Diagnostics areas in SQL/CLI. . 4.4.1 Introduction to diagnostics areas in SQL/CLI. 4.4.2 Setting of ROW_NUMBER and COLUMN_NUMBER fields. 4.5 Miscellaneous characteristics. 4.5.1 Handles. 12 4.5.2 Null-terminated strings. 4.5.3 Null pointers 4.5.4 Environment attributes. 4.5.5 Connection attributes. 13 4.5.6 Statement attributes. 4.5.7 CLI descriptor areas. 14 4.5.8 Obtaining diagnostics during multi-row fetch. 15 4.6 SQL-invoked routines. 4.6.1 ResultsetsreturnedbySQL-invokedprocedures. 4.7 Cursors. 4.7.1 General description of cursors. 16 4.8 Client-server operation. 5 Lexical elements. . .. 5.1 <token> and <separator>. 6 Call-Level Interface specifications. . ..18 6.1 <CLI routine>. 6.2 <CLI routine> invocation. . .26 6.3 Implicit set connection. . .29 6.4 Preparing a statement. . .30 6.5 Executing a statement. . .33 6.6 Implicit CLI prepared cursor. .35 6.7 Implicit CLI procedural result cursor. .37 @ IS0/IEC 2023 - All rights reserved iii IS0/IEC 9075-3:2023(E) 6.8 Initial CLI cursor. . 38 6.9 Implicit DESCRIBE USING clause. 39 6.10 Implicit EXECUTE USING and OPEN USING clauses 45 6.11 Implicit CALL USING clause. 6.12 Fetching a rowset... 6.13 Implicit FETCH USING clause. . 6.14 Character string retrieval. . . 6.15 Binary string retrieval. .. . 6.16 Deferred parameter check. . 6.17 Description of CLI item descriptor areas. 6.18 Other tables associated with CLI. . 6.19 SQL/CLI data type correspondences. .106 7 SQL/CLI routines. ..116 7.1 Introduction to SQL/CLI routines. . 116 7.2 AllocConnect(). . 116 7.3 AllocEnvO. .117 7.4 AllocHandleO. 118 7.5 AllocStmt(). .122 7.6 BindColO. . 123 7.7 BindParameterO. . . .125 7.8 Cancel(O). . 129 7.9 CloseCursorO).. 7.10 ColAttribute. . . 7.11 ColumnPrivilegesO. 7.12 ColumnsO.. . 7.13 ConnectO.. . 7.14 CopyDesc(). . ..153 7.15 DataSourcesO. . 7.16 DescribeColO.. .156 7.17 Disconnect().. .158 7.18 EndTranO.. .160 7.19 ErrorO. .164 7.20 ExecDirectO. 166 7.21 ExecuteO. 167 7.22 Fetch(). . 168 7.23 FetchScrollO. 169 7.24 ForeignKeysO. 170 7.25 FreeConnectO. . .182 7.26 FreeEnvO. . 183 7.27 FreeHandleO). . . .184 7.28 FreeStmtO... .187 7.29 GetConnectAttrO). 189 7.30 GetCursorNameO. 191 7.31 GetDataO. . 7.32 GetDescFieldO. .198 7.33 GetDescRecO... 7.34 GetDiagFieldO. . .202 iv @ IS0/IEC 2023 - All rights reserved IS0/IEC 9075-3:2023(E) 7.35 GetDiagRecO. .211 7.36 GetEnvAttrO. 213 7.37 GetFeaturelnfoO. 7.38 GetFunctionsO. 7.39 GetInfo(). 7.40 GetLengthO. 7.41 GetParamDataO. 7.42 GetPositionO. ...231 7.43 GetSessionInfoO. 7.44 GetStmtAttrO).. ..235 7.45 GetSubStringO. .238 7.46 GetTypelnfo(). .240 7.47 MoreResultsO). ..244 7.48 NextResult(). .245 7.49 NumResultColsO. .246 7.50 ParamDataO. .247 7.51 Prepare(). .252 7.52 PrimaryKeysO. 253 7.53 PutDataO. 258 7.54 RowCountO. .261 7.55 SetConnectAttrO. .262 7.56 SetCursorNameO. 264 7.57 SetDescFieldO. .266 7.58 SetDescRecO. . .271 7.59 SetEnvAttrO.. 273 7.60 SetStmtAttr