Properties - Connect_ETL - 9.13

Connect ETL ActiveX Reference

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
Language
English
Product name
Connect ETL
Title
Connect ETL ActiveX Reference
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-11
ft:lastPublication
2023-09-11T18:59:22.799064

DataFormat property

<DMExpressDelimitedField Class>.DataFormat

<DMExpressFixedPositionField Class>.DataFormat

Property definition

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 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.

FieldNumber property

<DMExpressDelimitedField Class>.FieldNumber

Property definition

Type Access Description
Long integer expression Write The number of the delimited field. The expression must have an integral value of 1 or greater. The fields in the source record are numbered from left to right, beginning with 1.

Notes

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