We assume that you have already learned what is described in:
If you want to find the right Reader for your purposes, see Readers Comparison.
DBFDataReader reads data from fixed-length dbase files.
Component | Data source | Input ports | Output ports | Each to all outputs1) | Different to different outputs2) | Transformation | Transf. req. | Java | CTL |
---|---|---|---|---|---|---|---|---|---|
DBFDataReader | dBase file | 0-1 | 1-n | yes | no | no | no | no | no |
Legend
1) Component sends each data record to all connected output ports.
2) Component sends different data records to different output ports using return values of the transformation. See Return Values of Transformations for more information.
DBFDataReader reads data from fixed-length dbase files (local or remote). It can also read data from compressed files, console, input port, or dictionary.
Port type | Number | Required | Description | Metadata |
---|---|---|---|---|
Input | 0 | no | For port reading. See Reading from Input Port. | One field (byte ,
cbyte , string ). |
Output | 0 | yes | For correct data records | Any1) |
1-n | no | For correct data records | Output 0 |
Legend:
1): Metadata on output ports can use Autofilling Functions.
Attribute | Req | Description | Possible values |
---|---|---|---|
Basic | |||
File URL | yes | Attribute specifying what data source(s) will be read (dbase file, console, input port, dictionary). See Supported File URL Formats for Readers. | |
Charset | Encoding of records that are read. | IBM850 (default) | <other encodings> | |
Data policy | Determines what should be done when an error occurs. See Data Policy for more information. | Strict (default) | Controlled | Lenient | |
Advanced | |||
Number of skipped records | Number of records to be skipped continuously throughout all source files. See Selecting Input Records. | 0-N | |
Max number of records | Maximum number of records to be read continuously throughout all source files. See Selecting Input Records. | 0-N | |
Number of skipped records per source | Number of records to be skipped from each source file. See Selecting Input Records. | Same as in Metadata (default) | 0-N | |
Max number of records per source | Maximum number of records to be read from each source file. See Selecting Input Records. | 0-N | |
Incremental file | 1) | Name of the file storing the incremental key, including path. See Incremental Reading. | |
Incremental key | 1) | Variable storing the position of the last read record. See Incremental Reading. |
Legend:
1) Either both or neither of these attributes must be specified.