Enables you to specify the name of the field that contains the length value for this field. Default is cleared.

The name of the field that contains the length value for the field. Enabled if you select the

Count Field

option.

Defines the field as a delimited field. Default is selected.

Includes the delimiter value in the field data. Enabled if you select the

Delimiter

option.

Excludes the delimiter value from the end of the field data. Default is selected. Enabled if you select the

Delimiter

option.

If the field is the last field in the record, defines an end-of-record marker when mapping variable-length records. Enabled if you select the

Delimiter

option and the field is the last field in the record. If you select this option, the

Value

box is disabled.

The delimiter value for a delimited field. Valid values are:

Enabled if you select the

Delimiter

option.

Data files for some data sources, such as DB2, might have fixed-length fields that contain variable-length data. In this case, the fields are padded. When you import this type of data, select this option to verify that PowerExchange handles padded fields correctly. For example, select this option when you import DB2 data that is sequentially accessed from an i5/OS system. Clear this option if the field is a variable-length field that is not padded. Default is cleared.