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

Notes

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

Length property

<DMExpressFixedPositionField Class>.Length

Property definition

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.

Notes

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

StartingByte property

<DMExpressFixedPositionField Class>.StartingByte

Property definition

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.

Notes

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