ISO/IEC INTERNATIONAL STANDARD 9075-10 Fifth edition 2023-06 Information technology Database languages SQL - Part 10: Object language bindings (SQL/OLB) Technologies de I'information - Langages de base de donneées TOS Partie 10: Liaisons de langage objet (SQL/OLB) Reference number IEC IS0/IEC 9075-10:2023(E) OS1 @ IS0/IEC 2023 IS0/IEC 9075-10: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 ISO/IEC 9075-10:20@(E) Contents Page Foreword.. . xvii Introduction. . XX 1 Scope.. 2 Normative references. . 3 Terms and definitions. 4 Concepts. 6 4.1 Notations and conventions. . 6 4.1.1 Notations. 4.1.2 First term usage. 4.1.3 Java-related conventions. 4.1.4 Specification of translator-generated classes. 4.2 Character strings. 4.2.1 Unicode support. 4.3 Embedded syntax. 4.4 Introduction to SQLJ. . 4.4.1 Overview 4.4.2 SQL constructs 4.4.3 SQLJ clauses. 4.4.4 Binary portability. 10 4.4.4.1 Binary portability requirements 10 4.4.4.2 Components of binary portable applications. 4.4.5 Profile overview.. 11 4.4.5.1 Introduction to profiles. . 11 4.4.5.2 EntrylInfo overview. 12 4.4.5.3 Typelnfo overview. 4.4.5.4 SQLJ datatype properties. 16 4.4.6 Host variables. 18 4.4.7 Host expressions.. 4.4.8 Connection contexts. . 4.4.9 Default connection context. . 4.4.10 Schema checking using exemplar schemas. . . . . 4.4.11 Using multiple SQLJ contexts and connections. . 4.4.12 Dynamic SQL and JDBC/SQLJ Connection interoperability. . : . ...20 4.4.12.1 Introduction to connection interoperability... 4.4.12.2 Creating an SQLJ ConnectionContext from a java. sql . Connection object. . ..20 4.4.12.3 Obtaining a java. sql . Connection object from an SQLJ ConnectionContext. . ..20 4.4.12.4 Connection sharing. . ..20 4.4.12.5 Connection resource management. . ..20 @ IS0/IEC 2023 - All rights reserved ili IS0/IEC 9075-10:2023(E) 4.4.13 SQL execution control and status. . .21 4.4.14 Iterators. .21 4.4.15 Input and output assignability. . . . . 4.4.16 Multiple java. sql .ResultSet objects from SQL-invoked procedure calls. . 4.4.16.1 Introduction to multiple result sets. . . . 4.4.16.2 Resource management with multiple results. . ....36 4.4.17 JDBC/SQLJ ResultSet interoperability. . . ....36 4.4.17.1 Introduction to interoperability. . . 4.4.17.2 Creating an SQLJ iterator from a java. sql .ResultSet object. . 4.4.17.3 Obtaining a java. sql .Result set object from an SQLJ iterator object. . . 4.4.17.4 Obtaining a java . sql . Result Set object from an untyped iterator object. 4.4.17.5 Iterator and java. sql .Result Set object resource management. 4.4.18 Multi-threading considerations. . ..38 4.4.19 User-defined data types. .38 4.4.20 Batch updates .39 4.4.20.1 Introduction to batch updates. 39 4.4.20.2 Batchable statements and batch compatibility. 39 4.4.20.3 Statement batching API. 39 4.4.20.4 Execution status and update counts. 40 4.4.20.5 Program semantics and exceptions. 40 4.4.20.6 Batch cancellation and disabling. 41 4.4.20.7 Specification of a batchinglimit.. 41 4.4.21 SQLJ language elements. . .42 4.4.21.1 Introduction to SQLJ language elements. .42 4.4.21.2 <cursor name>. .42 4.4.21.3 SQL-schema, SQL-data, and SQL-transaction statements. 4.4.21.4 <SQLdynamicstatement>. 4.4.21.5 <sQLconnectionstatement>. 4.4.21.6 <host variable definition>. . 4.4.21.7 <embedded exception declaration>. .. : ....43 4.4.21.8 <SQL diagnostics statement>. 4.4.21.9 Cursor declaration.. 4.4.21.10 Input parameters to SQL-statements. . 4.4.21.11 Extracting column value