Skip to main content
  • New archived content: Talend MDM, Talend Data Catalog 8.0, and Talend 7.3 products reached their end of life in 2024. Their documentation was moved to the Talend Archive page and will no longer receive content updates.

AS400 components

tAS400Close Closes the transaction committed in the connected database.
tAS400Commit Commits in one go a global transaction instead of doing that on every row or every batch, and provides gain in performance, using a unique connection.
tAS400Connection Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs.
tAS400Input Reads a database and extracts fields based on a query.
tAS400LastInsertId Obtains the primary key value of the record that was last inserted in an AS/400 table.
tAS400Output Writes, updates, makes changes or suppresses entries in a database.
tAS400Rollback Cancels the transaction commit in the connected database and avoids to commit part of a transaction involuntarily.
tAS400Row Executes the SQL query stated onto the specified database.

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!

Leave your feedback here