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.
tAS400Commit validates the data processed through the
Job into the connected database.
tAS400Commit Standard properties
These properties are used to configure tAS400Commit running in the Standard Job framework.
The Standard
tAS400Commit component belongs to the Databases family.
The component in this framework is available in all Talend
products.
connector. The properties related to database settings vary depending on your database
type selection. For more information about dynamic database connectors, see Dynamic database components.
Basic settings
Database |
Select a type of database from the list and click |
Component list |
Select the tAS400Connection component |
Close Connection |
This check box is selected by default. It allows you to close the Warning:
If you want to use a Row > Main |
Advanced settings
tStat |
Select this check box to collect log data at the component |
Usage
Usage rule |
This component is more commonly used with other tAS400* components, |
Dynamic settings |
Click the [+] button to add a row in the table Once a dynamic parameter is defined, the Component List box in the Basic For examples on using dynamic parameters, see Reading data from databases through context-based dynamic connections and Reading data from different MySQL databases using dynamically loaded connection parameters. For more information on Dynamic |
Related scenario
For a similar scenario using other database, see Inserting data in mother/daughter tables.