tDB2BulkExec
|
Executes the Insert action on the provided data and gains in performance during
Insert operations to a DB2 database. |
tDB2Close
|
Closes a transaction committed in the connected DB. |
tDB2Commit
|
Commits in one go a global transaction instead of doing that on every row or every
batch and thus provides gain in performance. |
tDB2Connection
|
Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs.
|
tDB2Input
|
Executes a DB query with a strictly defined order which must correspond to the
schema definition. Then tDB2Input passes on the field list to the
next component via a Row > Main link. |
tDB2Output
|
Executes the action defined on the table and/or on the data contained in the
table, based on the flow incoming from the preceding component in the Job. |
tDB2Rollback
|
Avoids to commit part of a transaction involuntarily. |
tDB2Row
|
Acts on the actual DB structure or on the data (although without handling data)
depending on the nature of the query and the database. The SQLBuilder tool helps you write
easily your SQL statements. |
tDB2SP
|
Offers a convenient way to call the database stored procedures. |