Component family |
Databases / AS/400 |
|
Function |
tAS400Input reads a database and |
|
Purpose |
tAS400SInput executes a DB query |
|
Basic settings |
Use an existing connection |
Select this check box and in the Component List click the NoteWhen a Job contains the parent Job and the child Job, if you need to share an existing
For an example about how to share a database connection across Job levels, see |
|
Property type |
Either Built-in or Repository. Since version 5.6, both the Built-In mode and the Repository mode are |
|
|
Built-in: No property data stored |
|
|
Repository: Select the repository |
|
Click this icon to open a database connection wizard and store the For more information about setting up and storing database |
|
|
DB Version |
Select the AS 400 version in use |
|
Host |
Database server IP address |
|
Port |
Listening port number of DB server. |
|
Database |
Name of the database |
|
Username and |
DB user authentication data. To enter the password, click the […] button next to the |
|
Schema and Edit |
A schema is a row description. It defines the number of fields to be processed and passed on Since version 5.6, both the Built-In mode and the Repository mode are This component offers the advantage of the dynamic schema feature. This allows you to This dynamic schema feature is designed for the purpose of retrieving unknown columns |
|
|
Built-in: The schema is created |
|
|
Repository: The schema already |
Click Edit schema to make changes to the schema. If the
|
||
|
Query type and Query |
Enter your DB query paying particularly attention to properly Warning
If using the dynamic schema feature, |
Advanced settings |
Additional JDBC parameters |
Specify additional connection properties for the DB connection you |
|
Trim all the String/Char columns |
Select this check box to remove leading and trailing whitespace |
|
Trim column |
Remove leading and trailing whitespace from defined |
|
tStat |
Select this check box to collect log data at the component |
Dynamic settings |
Click the [+] button to add a row in the table and fill The Dynamic settings table is available only when the For more information on Dynamic settings and context |
|
Usage |
This component offers the flexibility of the DB query and covers |
|
Log4j |
The activity of this component can be logged using the log4j feature. For more information on this feature, see Talend Studio User For more information on the log4j logging levels, see the Apache documentation at http://logging.apache.org/log4j/1.2/apidocs/org/apache/log4j/Level.html. |
For related topic, see tDBInput and tMysqlInput scenarios:
Related topic in tContextLoad, see Scenario: Reading data from different MySQL databases using dynamically loaded connection
parameters.