tAS400Output
Writes, updates, makes changes or suppresses entries in a database.
tAS400Output executes the action defined on the table and/or on the
data contained in the table, based on the flow incoming from the preceding component in
the Job.
tAS400Output Standard properties
These properties are used to configure tAS400Output running in the Standard Job
framework.
The Standard
tAS400Output 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 |
Property type |
Either Built-in or Repository. |
 |
Built-in: No property |
 |
Repository: Select the |
![]() |
Click this icon to open a database connection For more information about setting up and |
DB Version |
Select the AS/400 version in use |
Use an existing |
Select this check box and in the Component List click the relevant connection component to Note: When a Job contains the parent Job and the child Job, if you
need to share an existing connection between the two levels, for example, to share the connection created by the parent Job with the child Job, you have to:
For an example about how to share a database connection |
Host |
Database server IP address |
Port |
Listening port number of DB server. |
Database |
Name of the database |
Username and Password |
DB user authentication data. To enter the password, click the […] button next to the |
Table |
Name of the table to be written. Note that only |
Action on table |
On the table defined, you can perform one of
None: No operation is
Drop and create a table:
Create a table: The
Create a table if not
Drop a table if exists and
Clear a table: The table |
Action on data |
On the data of the table defined, you can
Insert: Add new entries
Update: Make changes to Insert or update: Insert a new record. If Update or insert: Update the record with the
Delete: Remove entries Warning:
It is necessary to specify at least one Note:
The dynamic schema feature can be used in |
Schema and Edit schema |
A schema is a row description. It defines the number of fields This This |
 |
Built-In: You create and store the schema locally for this component |
 |
Repository: You have already created the schema and stored it in the When the schema to be reused has default values that are You can find more details about how to |
 |
Click Edit
|
Die on error |
This check box is selected by default. Clear |
Advanced settings
Use commit control |
Select this check box to have access to the
Commit every: Enter the |
Additional JDBC |
Specify additional connection properties for Note:
You can press Ctrl+Space to access a list of predefined |
Additional Columns |
This option is not offered if you create (with |
 |
Name: Type in the name |
 |
SQL expression: Type in |
 |
Position: Select |
 |
Reference column: Type |
Use field options |
Select this check box to customize a request, |
Debug query mode |
Select this check box to display each step during processing entries |
Use Batch |
Select this check box to activate the batch mode for data processing. Note:
This check box is available only when you |
Batch Size |
Specify the number of records to be processed in each batch. This field appears only when the Use batch mode |
tStat |
Select this check box to collect log data at |
Enable parallel |
Select this check box to perform high-speed data processing, by treating
multiple data flows simultaneously. Note that this feature depends on the database or the application ability to handle multiple inserts in parallel as well as the number of CPU affected. In the Number of parallel executions field, either:
Note that when parallel execution is enabled, it is not possible to use global
|
Usage
Usage rule |
This component offers the flexibility benefit This component must be used as an output |
Dynamic settings |
Click the [+] button to add a row in the table The Dynamic settings table is 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 scenarios
For related scenario, see Handling data with AS/400.
For similar scenarios using other databases, see: