|
tPostgresPlusBulkExec
|
Improves performance during Insert operations to a DB2 database. |
|
tPostgresPlusClose
|
Closes the transaction committed in the connected PostgresPlus
database. |
|
tPostgresPlusCommit
|
Commits in one go a global transaction, using a unique connection, instead of doing
that on every row or every batch and thus improves performance. |
|
tPostgresPlusConnection
|
Opens a connection to the specified database that can then be reused in the subsequent subjob or subjobs.
|
|
tPostgresPlusInput
|
Executes a DB query with a strictly defined order which must correspond to the
schema definition. Then it passes on the field list to the next component via a Main row
link. |
|
tPostgresPlusOutput
|
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. |
|
tPostgresPlusOutputBulk
|
Prepares the file to be used as parameter in the INSERT query to
feed the PostgresPlus database. |
|
tPostgresPlusOutputBulkExec
|
Improves performance during Insert operations to a PostgresPlus
database. |
|
tPostgresPlusRollback
|
Avoids to commit part of a transaction involuntarily. |
|
tPostgresPlusRow
|
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. |
