DB2 V9.5 Adapter Limitations

Sales and inquiry support for DB2 V9.5 adapter has ended.

Supported Types
Read Table
Execute Select SQL
Write table
Execute Update SQL
Write by Loader
Main exceptions

Supported Types

This adapter supports types as follows.

Type name	Support	Remarks
SMALLINT	Yes
INTEGER	Yes
BIGINT	Yes
REAL	Yes
DOUBLE	Yes
DECIMAL	Yes
DATE	Yes
TIME	Yes
TIMESTAMP	Yes
CHAR	Yes
CHAR FOR BIT DATA	Limited
VARCHAR	Yes
VARCHAR FOR BIT DATA	Limited
LONG VARCHAR FOR BIT DATA	Limited
CLOB	Yes
BLOB	Limited
GRAPHIC	Yes
VARGRAPHIC	Yes
LONGVARGRAPHIC	Limited
DBCLOB	Limited

Yes: Support.
Limited: Support with limitations.
No: Not supported.

Read Table

Specification Limits

If the table name is enclosed by quotation marks, the table names are case-sensitive.

Execute Select SQL

Specification Limits

None

Write table

Specification Limits

CHAR
- The default code page when creating a database is "UTF-8". Therefore, depending on the character, string length may be longer, and the result may change from former operation.
If the table name is enclosed by quotation marks, the table names are case-sensitive.

Does not support batch update.

Execute Update SQL

Specification Limits

CHAR
- The default code page when creating a database is "UTF-8". Therefore, depending on the character, string length may be longer, and the result may change from former operation.
Does not support batch update.

Write by Loader

Specification Limits

CHAR
- The default code page when creating a database is "UTF-8". Therefore, depending on the character, string length may be longer, and the result may change from former operation.
The following types are not supported.
- LONG VARGRAPHIC
- DBCLOB
- BLOB
- CHAR FOR BIT DATA
- VARCHAR FOR BIT DATA
- LONG VARCHAR FOR BIT DATA

Notes

Refer to [TCP/IP service name (SVCENAME)] by executing "DB2 GET DBM CONFIG" command to check TCP service name of database instance.

Execute "DB2 CATALOG TCPIP NODE" command to add to node directory of the client.
Refer to "CATALOG TCPIP NODE command"(http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0001944.htm) For more information about the command.

Main exceptions

Exception name		Cause	Actions
java.sql.SQLException	IO Exception opening socket to server <hostname> on port <port>. The DB2 Server may be down. The DB2 Server may be down.	Cannot connect to the database.	Check the [Hostname] and [Port number].
	The application server rejected establishment of the connection. An attempt was made to access a database, dstes, which was not found.	database "<database name>" does not exist.	Make sure the specified database exists.
	Connection authorization failure occurred. Reason: password invalid.	Connected to the database but cannot login.	Check [User name]/[Password].
	DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: XXX; SELECT * FROM <table name>; <space>	Spaces may have been inserted into the specified table name.	Spaces may have been inserted into the [Table name]. In that case, enclose table name with quotation marks.
	DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: <table name>	"<table name>" does not exist.	Make sure the specified table exists.