DB2 V10.1 Adapter Limitations

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
XML	Limited	Treated as String data.

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.

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.

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

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
com.ibm.db2.jcc.am.SqlNonTransientConnectionException	Required property "<Host name>" is unclear. ERRORCODE=-4222, SQLSTATE=08001	Cannot connect to the database.	Check the [Host name] in global resource.
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException	Exception java.net.ConnectException: Error occurred upon opening sockets to Server /<Host name>. Port: <Port number> Message: Connection refused: connect ERRORCODE=-4499, SQLSTATE=08001		Check the [Port number] in global resource
com.ibm.db2.jcc.am.DisconnectNonTransientException	For the disperse protocol error causing release of allocating conversation, the execution failed. DRDA Data stream syntactic error was detected. Reason: 0x3. ERRORCODE=-4499, SQLSTATE=58009		Check the environment of the destination.
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException	While operating on the socket, socket input stream, or socket output stream that become the base of connection, communication error occurred. Location of error: Reply.fill() - socketInputStream.read (-1). Message: Software caused connection abort: recv failed. ERRORCODE=-4499, SQLSTATE=08001	You may be specifying database that does not exist.	Specify the existing database in [Database name] from the global resource.
com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException	Connection authorization failure occurred. Reason: password invalid. ERRORCODE=-4214, SQLSTATE=28000	User name or password is wrong.	Check [User name] or [Password]. in global resource.
com.ibm.db2.jcc.am.SqlSyntaxErrorException	DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=<Table name>, DRIVER=3.63.123	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.
com.ibm.db2.jcc.am.SqlSyntaxErrorException		Table does not exist.	Specify an existing table from [Table name].