DB2 Data Type Conversions
This section covers data type conversions between the Trifacta Application and DB2 databases.
Note
The Alteryx data types listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.
Access/Read
Source Data Type | Supported | Alteryx Data Type |
|---|---|---|
BOOLEAN | Y | Bool |
VARCHAR | Y | String |
INTEGER | Y | Integer |
Publish/Write
Alteryx Data Type | DB2 Data Type | Notes |
|---|---|---|
Bool | BOOLEAN | |
VARCHAR | ||
Integer | BIGINT | |
INT | ||
SMALLINT | ||
VARCHAR | ||
String | VARCHAR(1024) | |
Datetime | TIMESTAMP | |
VARCHAR | ||
Time | VARCHAR(1024) | |
Decimal | DECIMAL | |
NUMERIC | ||
VARCHAR | ||
Map | VARCHAR(1024) | |
Array | VARCHAR(1024) |