# AS400 components

| [tAS400Close](https://help.qlik.com/talend/en-US/components/8.0/as400/tas400close) | Closes the transaction committed in the connected database. |
| --- | --- |
| [tAS400Commit](https://help.qlik.com/talend/en-US/components/8.0/as400/tas400commit) | Commits in one go a global transaction instead of doing that on every row or<br>every batch, and provides gain in performance, using a unique connection. |
| [tAS400Connection](https://help.qlik.com/talend/en-US/components/8.0/as400/tas400connection) | Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs. |
| [tAS400Input](https://help.qlik.com/talend/en-US/components/8.0/as400/tas400input) | Reads a database and extracts fields based on a query. |
| [tAS400LastInsertId](https://help.qlik.com/talend/en-US/components/8.0/as400/tas400lastinsertid) | Obtains the primary key value of the record that was last inserted in an AS/400<br>table. |
| [tAS400Output](https://help.qlik.com/talend/en-US/components/8.0/as400/tas400output) | Writes, updates, makes changes or suppresses entries in a database. |
| [tAS400Rollback](https://help.qlik.com/talend/en-US/components/8.0/as400/tas400rollback) | Cancels the transaction commit in the connected database and avoids to commit<br>part of a transaction involuntarily. |
| [tAS400Row](https://help.qlik.com/talend/en-US/components/8.0/as400/tas400row) | Executes the SQL query stated onto the specified database. |