InformixDataWriter
Not available in Community Designer
| Short Description |
| Ports |
| Metadata |
| InformixDataWriter Attributes |
| Details |
| See also |
Short Description
InformixDataWriter loads data into an Informix database.
| Component | Data output | Input ports | Output ports | Transformation | Transf. required | Java | CTL | Auto-propagated metadata |
|---|---|---|---|---|---|---|---|---|
| InformixDataWriter | database | 0-1 | 0-1 |  | | | | |
Icon
Ports
| Port type | Number | Required | Description | Metadata |
|---|---|---|---|---|
| Input | 0 | [1] | Records to be loaded into the database | Any |
| Output | 0 | | For information about incorrect records | Input 0 (plus two Error Fields for InformixDataWriter [2]) |
[1] If no file containing data for loading (Loader input file) is specified, input port must be connected. [2] Metadata on the output port 0 contains two additional fields at their end:
| ||||
Metadata
InformixDataWriter does not propagate metadata.
Metadata on the output port 0 contains two additional fields
at their end: number of row, error message.
Table 54.3. Error Fields for InformixDataWriter
| Field number | Field name | Data type | Description |
|---|---|---|---|
| LastInputField + 1 | <anyname1> | integer | Number of row |
| LastInputField + 2 | <anyname2> | string | Error message |
InformixDataWriter Attributes
| Attribute | Req | Description | Possible values |
|---|---|---|---|
| Basic | |||
| Path to dbload utility | yes | Name of dbload utility, including path. Informix server must be installed and configured on the same machine where Clover runs and the user must be logged in as root. The dbload command line tool must be available. | |
| Host | Host where database server is located. | ||
| Database | yes | Name of the database into which the records should be loaded. | |
| Database table | yes | Name of the database table into which the records should be loaded. | |
| Advanced | |||
| Control script |
Control script to be used by the dbload utility.
If it is not set, the default control script is used instead.
Is used only if the Use load utility
attribute is set to false.
| ||
| Error log URL | Name of the error log file, including path. If not set, default error log file is used instead. | ./error.log | |
| Max error count | Maximum number of allowed records. When this number is exceeded, graph fails. | 10 (default) | 0-N | |
| Ignore rows |
Number of rows to be skipped.
Is used only if the
Use load utility attribute is set to
true.
| 0 (default) | 1-N | |
| Commit interval | Commit interval in number of rows. | 100 (default) | 1-N | |
| Column delimiter | One char delimiter used for each column in data. Field
values must not include this delimiter as their part.
Is used only if the Use load utility attribute is
set to false.
| "|" (default) | other character | |
| Loader input file | Name of input file to be loaded, including path.
Normally this file is a temporary storage for data to be
passed to dbload utility unless named pipe
is used instead. | ||
| Use load utility | By default, dbload utility is used to load data to database.
If set to true, load2 utility is
used instead of dbload.
The load2 utility must be available.
| false (default) | true | |
| User name |
Username to be used when connecting to the database.
Is used only if the Use load utility
attribute is set to true. | ||
| Password |
Password to be used when connecting to the database.
The password is used only if the Use load utility
attribute is set to true. | ||
| Ignore unique key violation | By default, unique key violation is not ignored.
If key values are not unique, graph fails.
If set to true, unique key violation is ignored.
The attribute is used only if the Use load utility
attribute is set to true.
| false (default) | true | |
| Use insert cursor | By default, insert cursor is used.
Using insert cursor doubles the transfer performance.
Is used only if the Use load utility attribute is set to
true.
It can be turned off by setting to false. | true (default) | false | |
Details
InformixDataWriter loads data into a database
using Informix database client (dbload
utility) or the load2 free library.
It is very important to have the server with the database on the
same computer as both the dbload database utility
and CloverETL and you must be logged in as the root user.
The Informix server must be installed and configured on
the same machine where Clover runs and the
user must be logged in as root.
The Dbload command line tool must also be available.
InformixDataWriter reads data from the input port or a file. If the input port is not connected to any other component, data must be contained in another file that should be specified in the component.
If you connect a component to the optional output port, rejected records along with information about errors are sent to it.
Another tool is the load2 free library
instead of the dbload utility.
The load2 free library can even be used if the server
is located on a remote computer.
Loader input file
Name of input file to be loaded, including path.
Normally this file is a temporary storage for data to be passed to dbload utility
unless named pipe is used instead.
If it is not set, a loader file is created in Clover or OS temporary directory. The file is deleted after the load finishes.
If it is set, specified file is created. It is not deleted after data is loaded and it is overwritten on each graph run.
If input port is not connected, this file must exist, must be specified and must contain data that should be loaded into database. It is not deleted or overwritten.