This section covers data type conversions between the Designer Cloud® 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) |
This page has no comments.