BS ISO/IEC 19075-3:2021
$142.49
Information technology. Guidance for the use of database language SQL – SQL embedded in programs using the JavaTM programming language
Published By | Publication Date | Number of Pages |
BSI | 2021 | 32 |
This document describes the support for the use of SQL within programs written in Java.
This document discusses the following features of the SQL language:
-
The embedding of SQL expressions and statements in programs written in the Java programming language
PDF Catalog
PDF Pages | PDF Title |
---|---|
2 | undefined |
5 | Contents |
7 | Foreword |
9 | Introduction |
11 | 1 Scope |
12 | 2 Normative references |
13 | 3 Terms and definitions |
14 | 4 Use of SQL in programs written in Java 4.1 Context of SQL programs written in Java 4.2 Design goals 4.3 Advantages of SQL/OLB over JDBC |
15 | 4.4 Consistency with existing embedded SQL languages 4.5 Profile customization overview 4.5.1 Introduction to profile customization |
16 | 4.5.2 Profile customization process |
17 | 4.5.3 Profile customization utilities 4.6 Examples 4.6.1 Example of profile generation and naming 4.6.2 Example of a JAR manifest file |
18 | 4.6.3 Host variables 4.6.4 Host expressions 4.6.5 SQL/OLB clauses |
19 | 4.6.6 Connection contexts 4.6.7 Default connection context |
20 | 4.6.8 Iterators 4.6.8.1 Positional bindings to columns 4.6.8.2 Named bindings to columns |
21 | 4.6.8.3 Providing names for columns of queries |
22 | 4.6.9 Invoking SQL-invoked routines 4.6.10 Using multiple SQL/OLB contexts and connections |
23 | 4.6.11 SQL execution control and status |
24 | 4.6.12 Multiple java.sql.ResultSet objects from SQL-invoked procedure calls |
25 | 4.6.13 Creating an SQL/OLB iterator object from a java.sql.ResultSet object 4.6.14 Obtaining a java.sql.ResultSet object from an iterator object |
26 | 4.6.15 Working with user-defined types |
27 | 4.6.16 Batching 4.6.17 Example program |
28 | 4.6.18 Host variable definition |