General tab
This tab allows configuring the field name of FRTNs generated by the filter and the delimiters used in the RRT values. This tab also allows specifying the data source, the database account’s credentials, and a table for retrieving data.
Option | Description |
---|---|
Field name | Enter the field name of the FRTN generated by the filter. |
Record delimiter | Enter record delimiter used in the RRT value. For example, ",". |
Column delimiter | Enter column delimiter used in the RRT value. For example, ";". |
Data source | This text box displays the data source through which the component accesses the database . To specify the data source and the
database account’s credentials, click ![]() |
Table name | Specify the name of the table from which the filter retrieves data. You can enter the table name manually or click ![]() |
Fail job if input/output is invalid | If this check box is selected, the component will reject the current job if there are no records in the result set. |
SQL Syntax group: | |
Default | Select this check box if you want to make query to a database other than Oracle or Informix. |
Oracle | Select this check box if you want to make query to an Oracle database. In this case the component will modify SQL query so that the Oracle database will consider it to be valid. |
Informix | Select this check box if you want to make query to an Informix database. |