Skip to main content

PostgresPlus components

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.

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 – please let us know!