DB2 V9.7 Adapter Limitations

Supported Types

This adapter supports types as follows.

Type name SupportRemarks
SMALLINTYes 
INTEGERYes 
BIGINTYes 
REALYes 
DOUBLEYes 
DECIMALYes 
DATEYes 
TIMEYes 
TIMESTAMPYes 
CHARYes 
CHAR FOR BIT DATALimited 
VARCHARYes 
VARCHAR FOR BIT DATALimited 
LONG VARCHAR FOR BIT DATALimited 
CLOBYes 
BLOBLimited 
GRAPHICYes 
VARGRAPHICYes 
LONGVARGRAPHICLimited 
DBCLOBLimited 

Read Table

Specification Limits

Execute Select SQL

Specification Limits

None

Write table

Specification Limits

Execute Update SQL

Specification Limits

Write by Loader

Specification Limits

Notes

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