Home | Table of Contents | InformixDataWriter | CloverETL 4.6.1
--- | --- | ---
Prev | Writers | Next

## 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: `number of row`, `error message`.

### 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 49.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.

### See also

Common Properties of Components
Specific Attribute Types
Common Properties of Writers
Writers Comparison

Prev | Up | Next
InfobrightDataWriter | Home | Table of Contents | JavaBeanWriter