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.9 |
Warning
End of Life Notice
IBM DB2 OLEDB connector will reach End of Life in December 2026, after which it will no longer be supported in the Alteryx Designer. Please consider migrating to IBM DB2 ODBC connector.
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.