Skip to main content

DB2 components

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!