IBM DB2 manual Bm.db2.luw.apdv.java.doc/doc/t0024156.html

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:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.i

bm.db2.luw.apdv.java.doc/doc/t0024156.html

4.1.2IBM 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.

Chapter 4. Deploying applications with DB2 143