Devart DB2 Destination

Devart DB2 Destination component loads data into DB2 tables. It has the following custom properties:

Property

Description

BatchSize

The maximal number of records to send as one batch to the server. 0 means that one commit will be issued at the end of the operation. Default value is 0.

BulkInsertKeepIdentity

Determines whether to send values supplied for identity columns to the target table. If false, the values for identity columns will be generated at the database side. Default value is False.

BulkInsertTableLock

Determines whether to acquire a table-level lock for the duration of the data loading operation. Default value is False.

BulkInsertTruncate

Determines whether to clear data of the target table before the operation. Default value is False.

Operation

A DML operation to apply to the target object. Default value is BulkInsert. The following values are supported:

•Insert - This is the most common operation.
•Update - Devart DB2 Destination component in the Update mode enables updating data in a data source. Peculiarity of this action consists in the fact, that performing it requires using primary key values of the target table (the Id value for cloud sources). Thus, when performing an update, you must know and specify the primary key values of the target table to update a record.
•Delete - Devart DB2 Destination component in the Delete mode enables deleting data from a data source. As well as for the update operation, you must know and specify the primary key values of the target table to delete a record.
•BulkInsert - Devart DB2 Destination component uses DB2-specific technique to quickly load data to DB2.

RetryCount

The number of times to retry loading the data in case if it fails. Default value is 5.

RetryInterval

The number of seconds before repeating an attempt to load data. Default value is 1.

TableName

The name of a DB2 database object to load data into.

Timeout

The number of seconds for the operation to complete before it times out. Default value is 0, which means that the operation never times out.