Properties - Connect_ETL

DataFormat property

<DMExpressDelimitedField Class>.DataFormat

<DMExpressFixedPositionField Class>.DataFormat

Type	Access	Description
DMExpress format code	Read/write	The format of the data in the field when the data is in a standard DMExpress format. The initial setting is dmxDataCharacter (character/text string).
IDMExpressDateTimeFormat	Read/write	An interface providing the pattern that describes how a date and/or a time is formatted in the field when it is not in the standard DMExpress date/time format. The standard DMExpress date/time format is MM0/DD0/YEAR HH0:MI0:SE0.

You can change this property at any time before adding the field as a sort/merge field via AddKey.

<DMExpressFixedPositionField Class>.Length

Type

Access

Description

Long integer expression

Write

The length of the field in bytes.

>0 the actual length of a field which has the same length in all records.
0 indicating that a field extends to the end of record. The length of this field may vary from record to record.

You can change this property at any time before adding the field as a sort/merge field via AddKey.

<DMExpressFixedPositionField Class>.StartingByte

Type	Access	Description
Long integer expression	Write	The byte position at which the field starts. The expression must have an integral value of 1 or greater. The first position within the data portion of the record is byte position 1.

You can change this property at any time before adding the field as a sort/merge field via AddKey.