Driver for odbc and cli – IBM Data Server DB2 User Manual
Page 157
Chapter 4. Deploying applications with DB2
143
You might want to redirect the output to a file for easier viewing. The
JDK_PATH field appears near the beginning of the output.
Date and time format:
If you plan to call the SQL procedures that are on the DB2 servers from a
Java program, and the date and time format that is associated with the
territory code of the database servers is not the USA format, take the
following actions:
a. On database server, set the DB2_SQLROUTINE_PREPOPTS registry
variable to indicate that the default date and time format is
ISO
:
db2set DB2_SQLROUTINE_PREPOPTS="DATETIME ISO"
b. Redefine any existing SQL procedures that you plan to call from Java
programs.
These steps are necessary to ensure that the calling application receives
date and time values correctly.
Access DB2 for z/OS database:
If you plan to access DB2 for z/OS database servers with your Java
applications, follow the instructions at the following site:
4.1.2 IBM Data Server Driver for ODBC, CLI, and .NET, and IBM Data
Server Driver for ODBC and CLI
The IBM Data Server Driver for ODBC, CLI, and .NET, and IBM Data Server
Driver for ODBC and CLI provides a lightweight deployment solution for
applications that utilize the DB2 CLI application programming interface (API),
ODBC API, or .NET API (on Windows only).
The only distinction between the IBM Data Server Driver for ODBC, CLI, and
.NET, and IBM Data Server Driver for ODBC and CLI is that IBM Data Server
Driver for ODBC, CLI, and .NET is the driver name for the Windows platform,
which includes .NET API support, while the other is for Linux and UNIX, which do
not have .NET API support.
This driver is not a part of the IBM Data Server Client or IBM Data Server
Runtime client, although both the IBM Data Server Client and IBM Data Server
Runtime client support CLI and ODBC API. The IBM Data Server Driver for
ODBC and CLI and IBM Data Server Driver for ODBC, CLI, and .NET are
available as a separate install.