Property | S/T | Description |
|---|---|---|
CodePage | S/T | This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US. |
Allow duplicate keys | T | Allows duplicate records in an indexed type target file. If true, duplicate records are allowed; if set to false, a "duplicate record found" error is returned for all duplicate records. Although this property is visible for relative and sequential file types, it is NOT supported (the default value is true for these types). |
FileType | S/T | This connector has one property, and the setting is not optional. The default is indexed. From the list, choose one of the following file types: • indexed (default) – Contains records that have one or more key fields. Records in an indexed file are ordered by ascending values in these key fields. Each key of an indexed file represents an ordered sequence by which the records can be accessed. One of the key fields, known as the primary key, must contain a unique value for each record and is used to identify records uniquely. • relative – Contains records that are identified by their record number, where the first record in the file is record number one. Relative files are ordered by ascending record numbers. • sequential – Ordered by the historical order in which records are written to the file. For an important note on this file type, see Connector-Specific Notes. If you leave the file type set to default and then select a relative or sequential file, an error displays that it cannot open the data source. Select the FileType setting first and then select your source or target file. To append indexed data to an existing target file, that file must also be indexed. |