File System Connector Properties

The following table defines the properties for the Connector for File System.

Token

Name/Description

Type

LCTOKEN_DATABASE

Database

Path to the directories (C:\files\somefiles or /unix/usr/files). Required.

Text

LCTOKEN_METADATA

Metadata

The subdirectory name (mydirectory or somedir/mydir). This subdirectory contains the files you want to access.

Text

LCTOKEN_MAP_NAME

MapByName

Whether to map by name or position when transferring data between data source and target.

Boolean

LCTOKEN_WRITEBACK

Writeback

Whether to perform writeback or non-writeback operations.

Boolean

LCTOKEN_FIELDNAMES

FieldNames

Multi-value text list of fields to select - used for Select operations

Text List

LCTOKEN_ORDERNAMES

OrderNames

Multi-value text list of fields to order results by - used for Select operations

Text List

LCTOKEN_CONDITION

Condition

The file specification for the files to include. The specification can include the standard wildcard characters: * to match any character string; ? to match any single character.

Text

LCTOKEN_STAMPFIELD

StampField

Field name of timestamp field -- used for Select operations

Text

LCTOKEN_BASESTAMP

BaseStamp

Minimum timestamp value to include in results -- used for Select operations

Datetime

LCTOKEN_MAXSTAMP

MaxStamp

During a Select operations, set by the connector to the current timestamp value -- set by Select operations

Datetime

1.00

Binary

Whether file contents should be treated as binary (BLOB) data rather than the default (native TEXT).

Boolean

2.00

Sort

Defines the sort order in the case of ordering by filename (0 = binary, 1 = case sensitive, 2 = case insensitive).

Integer

File System Metadata

File system metadata is defined as follows:

Filename -- Text

Contents -- Text

Timestamp -- Datetime

Size -- Int