DB2 for i 7.2 Adapter Limitations

Supported Types
Common to all processing
Read Table
Execute Select SQL
Write table
Execute Update SQL

Supported Types

This adapter supports types as follows.

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

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

Common to all processing

Specification Limits

Physical file information created as fixed-length file is shown in the table list.

Notes

To connect to DB2 for i 7.2 from DataSpider, it is required to enable QUSER user profile, start the host server, and start TCP/IP server.
Refer to http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzahh/rzahnm05.htm for details.

When there is no journal in the specified library,or journal processing is stopped,put the check in [Perform auto-commit] of global resource settings. If unchecked, the error occurs during the writing process (Error code: SQL7008).

In Global resource settings, if [Perform auto-commit] is checked, the process is not rolled back, even if an error occurs during processing, data is updated by the operation executed so far.

This adapter can be used when the independent auxiliary storage pool (IASP) function of System i is enabled.

Read Table

Specification Limits

None

Execute Select SQL

Specification Limits

None

Write table

Specification Limits

DECIMAL
- Insertion of 0 (zero) is supported till the sixth figure after the decimal point.

Execute Update SQL

Specification Limits

DECIMAL
- Insertion of 0 (zero) is supported till the sixth figure after the decimal point.