Data format code - 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

The DataFormat property of a field object indicates in which standard DMExpress format the data are stored in the field. The property can have any of the following integer values.

Value to use Suggested mnemonic To indicate
1 dmxDataBinaryDFloat a double precision floating point number
2 dmxDataBinaryFloat a single precision floating point number
3 dmxDataBinaryInt a signed binary integer number
4 dmxDataBinaryIntBigEnd a signed binary integer number in big-endian form
5 dmxDataBinaryUInt an unsigned binary integer number
6 dmxDataBinaryUIntBigEnd an unsigned binary integer number in big-endian form.
7 dmxDataCharacter a character (text) string
8 dmxDataDateTime a date and a time in standard DMExpress date/time format - MM0/DD0/YEAR HH0:MI0:SE0. To access a date field in another format, use the custom interface IDMExpressDateTimeFormat.
9 dmxDataEditedNumeric an edited numeric number
10 dmxDataLeadingSignDecimal a signed decimal with leading separate sign number
11 dmxDataLeadingEmbeddedSign0 a signed decimal with leading embedded sign, Micro Focus form number
12 dmxDataLeadingEmbeddedSign1 a signed decimal with leading embedded sign, alternative form number
13 dmxDataTrailingSignDecimal a signed decimal with trailing separate sign number
14 dmxDataTrailingEmbeddedSign0 a signed decimal with trailing embedded sign, Micro Focus form number
15 dmxDataTrailingEmbeddedSign1 a signed decimal with trailing embedded sign, alternative form number
16 dmxDataUnsignedDecimal an unsigned decimal number
17 dmxDataPackedDecimal a packed decimal number
18 dmxDataScientificNotation a scientific notation number