
tInformixOutputBulk and tInformixBulkExec are generally used together in a two step process. In
the first step, an output file is generated. In the second step, this file is used in
the INSERT operation used to feed a database. These two steps are fused together in the
tInformixOutputBulkExec
component, detailed in another section. The advantage of using two components
is that data can be transformed before it is loaded in the database.
Component Family |
Databases/Informix |
|
Function |
tInformixBulkExec executes Insert |
|
Purpose |
tInformixBulkExec is a dedicated |
|
Basic settings |
Property type |
Either Built-in or Since version 5.6, both the Built-In mode and the Repository mode are |
|
|
Built-in: No property data stored |
|
|
Repository: Select the repository |
|
Execution Platform |
Select the operating system you are using. |
|
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 |
|
Host |
Database server IP address. |
|
Port |
DB server listening port. |
|
Database |
Name of the database. |
|
Schema |
Name of the schema. |
|
Username and |
DB user authentication data. To enter the password, click the […] button next to the |
|
Instance |
Name of the Informix instance to be used. This information can |
|
Table |
Name of the table to be written. Note that only one table can be |
|
Action on table |
On the table defined, you can perform one of the following
None: No operation is carried
Drop and create a table: The table
Create a table: The table does not
Create a table if not exists: The
Drop a table if exists and create:
Clear a table: The table content is |
|
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 |
|
|
Built-In: You create and store the schema locally for this |
|
|
Repository: You have already created the schema and When the schema to be reused has default values that are integers or functions, ensure that For more details, see https://help.talend.com/display/KB/Verifying+default+values+in+a+retrieved+schema. |
Click Edit schema to make changes to the schema. If the
|
||
|
Informix Directory |
Informix installation directory, e.g. ” |
|
Data file |
Name of the file to be loaded. |
|
Action on data |
On the data of the table defined, you can perform the following
Insert: Add new data to the table.
Update: Update the existing table Insert or update: Insert a new record. If the record with Update or insert: Update the record with the given
Delete: Delete the entry data which Warning
You must specify at least one key upon |
Advanced settings |
Additional JDBC parameters |
Specify additional connection properties for the DB connection you |
|
Field terminated by |
Character, string or regular expression which separates the |
|
Set DBMONEY |
Select this check box to define the decimal separator in the |
|
Set DBDATE |
Select the date format that you want to apply. |
|
Rows Before Commit |
Enter the number of rows to be processed before the commit. |
|
Bad Rows Before Abort |
Enter the number of rows in error at which point the Job should |
|
tStat |
Select this check box to colelct the log data at component |
|
Output |
Where the output should go. |
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 |
|
Global Variables |
NB_LINE: the number of rows processed. This is an After
NB_LINE_UPDATED: the number of rows updated. This is an
NB_LINE_INSERTED: the number of rows inserted. This is an
NB_LINE_DELETED: the number of rows deleted. This is an
QUERY: the SQL query statement processed. This is an After ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see Talend Studio |
|
Usage |
This component offers database query flexibility and covers all |
|
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. |
|
Limitation |
The database server/client must be installed on the same machine This component requires installation of its related jar files. For more information about the |
For a scenario in which tInformixBulkExec might be
used, see: