EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #7 background imageLoading...
Page #7 background image
Chapter 6. Preparing and running JDBC and SQLJ programs ............183
Program preparation for JDBC programs .........................183
Program preparation for SQLJ programs .........................183
Binding SQLJ applications to access multiple database servers ..................185
Program preparation for Java routines ..........................187
Preparation of Java routines with no SQLJ clauses .....................187
Preparation of Java routines with SQLJ clauses ......................188
Creating JAR files for Java routines ..........................191
Running JDBC and SQLJ programs ...........................192
Chapter 7. JDBC and SQLJ reference information.................193
Data types that map to database data types in Java applications .................193
Date, time, and timestamp values that can cause problems in JDBC and SQLJ applications .......200
Properties for the IBM Data Server Driver for JDBC and SQLJ ..................201
Common IBM Data Server Driver for JDBC and SQLJ properties for all supported database products ....203
Common IBM Data Server Driver for JDBC and SQLJ properties for DB2 servers...........215
Common IBM Data Server Driver for JDBC and SQLJ properties for DB2 for z/OS and IDS .......224
Common IBM Data Server Driver for JDBC and SQLJ properties for IDS and DB2 Database for Linux, UNIX,
and Windows .................................225
IBM Data Server Driver for JDBC and SQLJ properties for DB2 Database for Linux, UNIX, and Windows . . 226
IBM Data Server Driver for JDBC and SQLJ properties for DB2 for z/OS .............228
IBM Data Server Driver for JDBC and SQLJ properties for IDS .................233
IBM Data Server Driver for JDBC and SQLJ configuration properties ................239
Driver support for JDBC APIs .............................252
SQLJ statement reference information ..........................281
SQLJ clause ..................................281
SQLJ host-expression ...............................281
SQLJ implements-clause ..............................282
SQLJ with-clause ................................283
SQLJ connection-declaration-clause ..........................285
SQLJ iterator-declaration-clause ...........................285
SQLJ executable-clause ..............................287
SQLJ context-clause ...............................288
SQLJ statement-clause ..............................288
SQLJ SET-TRANSACTION-clause ..........................290
SQLJ assignment-clause ..............................291
SQLJ iterator-conversion-clause ...........................291
Interfaces and classes in the sqlj.runtime package ......................292
sqlj.runtime.ConnectionContext interface ........................293
sqlj.runtime.ForUpdate interface ...........................298
sqlj.runtime.NamedIterator interface..........................298
sqlj.runtime.PositionedIterator interface.........................299
sqlj.runtime.ResultSetIterator interface .........................299
sqlj.runtime.Scrollable interface ...........................302
sqlj.runtime.AsciiStream class ............................304
sqlj.runtime.BinaryStream class ...........................305
sqlj.runtime.CharacterStream class ..........................306
sqlj.runtime.ExecutionContext class ..........................307
sqlj.runtime.SQLNullException class ..........................314
sqlj.runtime.StreamWrapper class ...........................314
sqlj.runtime.UnicodeStream class ...........................316
IBM Data Server Driver for JDBC and SQLJ extensions to JDBC .................316
DBBatchUpdateException interface ..........................318
DB2BaseDataSource class .............................319
DB2ClientRerouteServerList class ...........................324
DB2Connection interface .............................326
DB2ConnectionPoolDataSource class .........................341
DB2DatabaseMetaData interface ...........................343
DB2Diagnosable interface .............................344
DB2ExceptionFormatter class ............................344
DB2JCCPlugin class ...............................345
Contents v
||

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability