CONNX Data Integration Suite 14.7.0 | Reference Guide | Data Types | Non-Relational Databases | DataFlex/PowerFlex Data Types
 
DataFlex/PowerFlex Data Types
The following table contains the available data types for DataFlex/PowerFlex databases supported by CONNX.
DataFlex Data Type
SQL Data Type
Length
Description
Binary (Text)
CHAR
-1
Flex Binary
Binary
1-32000
Binary value
Flex Date
DATE
10
Date in ODBC format. DataFlex date can be in the MM/DD/YY or MM/DD/YYYY format.
Flex Double
DOUBLE
TSZ
Flex Longword
INTEGER
TSZ
Flex Text
CHAR
1-32000
Alphanumeric and symbols (1-32000 chars).
Flex Numeric
DECIMAL
-1
Dataflex numeric to SQL Decimal
Text -> Currency
CURRENCY
-1
Text (Right Space Padded)
CHAR
-1