IBM DB2
Connection Type | ODBC and OLEDB (64-bit) |
Driver Details | The ODBC or OLEDB driver can be downloaded from IBM DB2. |
Type of Support | Read & Write |
Validated On | 11.5 |
Alteryx Tools Used to Connect
Standard Workflow Processing
Additional Details
OLEDB has issues with NULL vs. Empty in some cases. Use ODBC.
Limitations
Maximum Columns in Table: 1012
Maximum Column Name Length: 128 Characters
Maximum Row Size: 32677 Bytes (does not include LOB size)
Maximum Columns In Table: 1012
Maximum Column Name Length: 30 Characters
Maximum Row Size: 32677 Bytes (does not include LOB size)
32- and 64-bit: Fixed Numeric is transported as a CHAR, SQL_NUMERIC not supported.
32-bit: No Issues
64 bit: Version: 9.01.301.314 (differences between NULL and EMPTY)
64 bit: Version: 9.5.0.808 (only BLOB and VString seem to work)
Known Issues
A single workflow with ODBC connections cannot contain OleDB connections using the same driver.