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 . This button opens the Data Source dialog box.
Table name Specify the name of the table from which the filter retrieves data. You can enter the table name manually or click to select a table in the Select Table dialog box.
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.