Skip to main content

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 – let us know how we can improve!