tAS400Connection
Opens a connection to the specified database that can then be reused in the
subsequent subjob or subjobs.
tAS400Connection opens a connection to
the database for a current transaction.
tAS400Connection Standard properties
These properties are used to configure tAS400Connection running in the Standard Job framework.
The Standard
tAS400Connection component belongs to the Databases and the ELT families.
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 |
Property type |
Either Built-in or |
 |
Built-in: No property data stored |
 |
Repository: Select the repository file |
DB Version |
Select the AS/400 version in use |
Host |
Database server IP address |
Database |
Name of the database |
Username and Password |
DB user authentication data. To enter the password, click the […] button next to the |
Use or register a shared DB Connection |
Select this check box to share your This option is |
Advanced settings
Additional JDBC parameters |
Specify additional connection properties for the DB connection you are |
Auto Commit |
Select this check box to commit any changes to the database With this check box selected, you cannot use the corresponding Note that the auto commit function commits each SQL statement as a |
tStatCatcher Statistics |
Select this check box to gather the job processing metadata at a Job |
Usage
Usage rule |
This component is more commonly used with other tAS400* components, |
Related scenario
For similar scenarios using other database, see tMysqlConnection.