Shopping Cart

No products in the cart.

BSI 22/30453904 DC 2022

$45.21

BS EN ISO IEC 9075-10. Information technology. Database language SQL – Part 10. Object language bindings (SQL/OLB)

Published By Publication Date Number of Pages
BSI 2022 340
Guaranteed Safe Checkout
Category:

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

PDF Catalog

PDF Pages PDF Title
5 Contents
19 Tables
20 Foreword
22 Introduction
25 1 Scope
26 2 Normative references
27 3 Terms and definitions
30 4 Concepts
4.1 Notations and conventions
4.1.1 Notations
4.1.2 First term usage
4.1.3 Java-related conventions
31 4.1.4 Specification of translator-generated classes
32 4.2 Character strings
4.2.1 Unicode support
4.3 Embedded syntax
4.4 Introduction to SQLJ
4.4.1 Overview
33 4.4.2 SQL constructs
4.4.3 SQLJ clauses
4.4.4 Binary portability
4.4.4.1 Binary portability requirements
35 4.4.4.2 Components of binary portable applications
4.4.5 Profile overview
4.4.5.1 Introduction to profiles
36 4.4.5.2 EntryInfo overview
38 4.4.5.3 TypeInfo overview
39 4.4.5.4 SQLJ datatype properties
41 4.4.6 Host variables
42 4.4.7 Host expressions
4.4.8 Connection contexts
4.4.9 Default connection context
43 4.4.10 Schema checking using exemplar schemas
4.4.11 Using multiple SQLJ contexts and connections
44 4.4.12 Dynamic SQL and JDBC/SQLJ Connection interoperability
4.4.12.1 Introduction to connection interoperability
4.4.12.2 Creating an SQLJ ConnectionContext from a java.sql.Connection object
4.4.12.3 Obtaining a java.sql.Connection object from an SQLJ ConnectionContext
4.4.12.4 Connection sharing
4.4.12.5 Connection resource management
45 4.4.13 SQL execution control and status
4.4.14 Iterators
46 4.4.15 Input and output assignability
60 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
4.4.17 JDBC/SQLJ ResultSet interoperability
4.4.17.1 Introduction to interoperability
4.4.17.2 Creating an SQLJ iterator from a java.sql.ResultSet object
61 4.4.17.3 Obtaining a java.sql.ResultSet object from an SQLJ iterator object
4.4.17.4 Obtaining a java.sql.ResultSet object from an untyped iterator object
4.4.17.5 Iterator and java.sql.ResultSet object resource management
62 4.4.18 Multi-threading considerations
4.4.19 User-defined data types
63 4.4.20 Batch updates
4.4.20.1 Introduction to batch updates
4.4.20.2 Batchable statements and batch compatibility
4.4.20.3 Statement batching API
64 4.4.20.4 Execution status and update counts
4.4.20.5 Program semantics and exceptions
65 4.4.20.6 Batch cancellation and disabling
4.4.20.7 Specification of a batching limit
66 4.4.21 SQLJ language elements
4.4.21.1 Introduction to SQLJ language elements
4.4.21.2
4.4.21.3 SQL-schema, SQL-data, and SQL-transaction statements
67 4.4.21.4
4.4.21.5
4.4.21.6
4.4.21.7
4.4.21.8
68 4.4.21.9 Cursor declaration
4.4.21.10 Input parameters to SQL-statements
4.4.21.11 Extracting column values from SQLJ iterators
4.4.21.12 and cursors
69 4.4.22 SQLJ, JDBC, and SQLExceptions and SQLWarnings
4.4.23 Profile generation and naming
70 4.4.24 SQLJ application packaging
4.4.25 Profile customizer interface
71 4.4.26 Customization interface
4.4.26.1 Introduction to customization interfaces
4.4.26.2 Customization usage
72 4.4.26.3 Customization registration
74 5 Lexical elements
5.1
75 5.2 and
76 6 Scalar expressions
6.1 and
77 7 Additional common rules
7.1 Invoking an SQL-invoked routine
78 8 Data manipulation
8.1
81 8.2
85 8.3
87 8.4
89 9 Control statements
9.1
91 9.2
93 9.3
95 10 Transaction management
10.1
96 10.2
97 10.3
98 10.4
99 10.5
100 11 Embedded SQL
11.1
102 11.2
103 12 SQLJ reserved names
12.1 Introduction to reserved names
12.2 Naming runtime library components
12.3 Temporary variable names
12.4 Class and resource file names
12.4.1 Introduction
12.4.2 Generated classes
104 12.4.3 Resource files and profiles
105 13 Common subelements
13.1
106 13.2
107 13.3
108 13.4
109 13.5
110 13.6
113 13.7
114 13.8
117 14 and contents
14.1
118 14.2
119 14.3 Generated connection class
124 14.4
126 14.5
127 14.6 Generated positioned iterator class
129 14.7
130 14.8 Generated named iterator class
132 14.9
138 14.10
139 14.11
140 14.12
142 14.13
146 14.14
148 14.15
151 15 Package sqlj.runtime
15.1 Overview
15.2 SQLJ runtime interfaces
15.2.1 sqlj.runtime.ConnectionContext
15.2.1.1 Interface Overview
152 15.2.1.2 Variables
15.2.1.3 Methods
155 15.2.2 sqlj.runtime.ForUpdate
15.2.2.1 Interface Overview
15.2.2.2 Methods
15.2.3 sqlj.runtime.NamedIterator
156 15.2.4 sqlj.runtime.PositionedIterator
15.2.4.1 Interface Overview
15.2.4.2 Methods
157 15.2.5 sqlj.runtime.ResultSetIterator
15.2.5.1 Interface Overview
15.2.5.2 Variables
158 15.2.5.3 Methods
162 15.2.6 sqlj.runtime.Scrollable
15.2.6.1 Interface Overview
15.2.6.2 Variables
15.2.6.3 Methods
167 15.3 SQLJ Runtime Classes
15.3.1 sqlj.runtime.AsciiStream
15.3.1.1 Class Overview
15.3.1.2 Constructors
168 15.3.2 sqlj.runtime.BinaryStream
15.3.2.1 Class Overview
15.3.2.2 Constructors
169 15.3.3 sqlj.runtime.DefaultRuntime
15.3.3.1 Class Overview
15.3.3.2 Constructors
15.3.3.3 Methods
170 15.3.4 sqlj.runtime.ExecutionContext
15.3.4.1 Class Overview
171 15.3.4.2 Variables
172 15.3.4.3 Constructors
15.3.4.4 Methods
185 15.3.5 sqlj.runtime.RuntimeContext
15.3.5.1 Class Overview
15.3.5.2 Variables
186 15.3.5.3 Constructors
15.3.5.4 Methods
187 15.3.6 sqlj.runtime.StreamWrapper
15.3.6.1 Class Overview
188 15.3.6.2 Constructors
15.3.6.3 Methods
189 15.3.7 sqlj.runtime.UnicodeStream
15.3.7.1 Class Overview
15.3.7.2 Constructors
190 15.3.8 sqlj.runtime.CharacterStream
15.3.8.1 Class Overview
15.3.8.2 Constructors
191 15.3.8.3 Methods
15.3.9 sqlj.runtime.SQLNullException
15.3.9.1 Class Overview
192 15.3.9.2 Constructors
193 16 Package sqlj.runtime.profile
16.1 Overview
16.2 SQLJ sqlj.runtime.profile Interfaces
16.2.1 sqlj.runtime.profile.BatchContext
16.2.1.1 Interface Overview
16.2.1.2 Methods
194 16.2.2 sqlj.runtime.profile.ConnectedProfile
16.2.2.1 Interface Overview
195 16.2.2.2 Methods
197 16.2.3 sqlj.runtime.profile.Customization
16.2.3.1 Interface Overview
198 16.2.3.2 Methods
199 16.2.4 sqlj.runtime.profile.Loader
16.2.4.1 Interface Overview
16.2.4.2 Methods
200 16.2.5 sqlj.runtime.profile.RTResultSet
16.2.5.1 Interface Overview
203 16.2.5.2 Methods
228 16.2.6 sqlj.runtime.profile.RTStatement
16.2.6.1 Interface Overview
233 16.2.6.2 Methods
280 16.2.7 sqlj.runtime.profile.SerializedProfile
16.2.7.1 Interface Overview
16.2.7.2 Methods
281 16.3 SQLJ sqlj.runtime.profile Classes
16.3.1 sqlj.runtime.profile.DefaultLoader
16.3.1.1 Class Overview
16.3.1.2 Constructors
16.3.1.3 Methods
282 16.3.2 sqlj.runtime.profile.EntryInfo
16.3.2.1 Class Overview
16.3.2.2 Variables
288 16.3.2.3 Constructors
16.3.2.4 Methods
298 16.3.3 sqlj.runtime.profile.Profile
16.3.3.1 Class Overview
16.3.3.2 Constructors
299 16.3.3.3 Methods
305 16.3.4 sqlj.runtime.profile.ProfileData
16.3.4.1 Class Overview
16.3.4.2 Constructors
306 16.3.4.3 Methods
307 16.3.5 sqlj.runtime.profile.SetTransactionDescriptor
16.3.5.1 Class Overview
16.3.5.2 Variables
308 16.3.5.3 Constructors
16.3.5.4 Methods
309 16.3.6 sqlj.runtime.profile.TypeInfo
16.3.6.1 Class Overview
16.3.6.2 Variables
310 16.3.6.3 Constructors
16.3.6.4 Methods
315 17 sqlj.runtime.profile.util.ProfileCustomizer
17.1 Interface Overview
317 17.2 Methods
17.2.1 acceptsConnection (Connection)
17.2.2 customize (Profile, Connection, ErrorLog)
319 18 Status codes
18.1 SQLSTATE
320 19 Conformance
19.1 Claims of conformance to SQL/OLB
19.2 Additional conformance requirements for SQL/OLB
19.3 Implied feature relationships of SQL/OLB
321 A SQL Conformance Summary
324 B Implementation-defined elements
327 C Implementation-dependent elements
331 D SQL optional feature taxonomy
333 E Deprecated features
334 F Incompatibilities with ISO/IEC 9075:2016
335 G Defect reports not addressed in this edition of this document
336 Bibliography
337 Index
BSI 22/30453904 DC 2022
$45.21