DB2 V9.1 Adapter Limitations

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

Supported Types

This adapter supports types as follows.
name SupportRemarks
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 

Read Table Limitations

Execute Select SQL Limitations

None.

Write Table Limitations

Execute Update SQL Limitations

Restriction on writing by loader

About Client Tools

Supported Client Version

Notes

Main exception messages

Exception Name Message Cause / Solution
java.sql.SQLException IO Exception opening socket to server <hostname> on port <port>. The DB2 Server may be down. Cannot connect to the database.Please check the host name and port number.
The application server rejected establishment of the connection. An attempt was made to access a database, dstes, which was not found. Make sure the specified table exists.
Connection authorization failure occurred. Reason: password invalid. Please check the specified user name or 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. In that case, enclose table name with quotation marks.
DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: <table name> Make sure the specified table exists.