IBM DB2
Version:
2023.1
Last modified: May 17, 2023
| 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 | 9.5.0, 10.5 |
Alteryx Tools Used to Connect
Standard Workflow Processing
Additional Details
OLEDB has issues with NULL vs. Empty in some cases. Use ODBC.
Limitations
Database Version: 10.5
- Maximum Columns in Table: 1012
- Maximum Column Name Length: 128 Characters
- Maximum Row Size: 32677 Bytes (does not include LOB size)
Database Version: 9.5.0
- Maximum Columns In Table: 1012
- Maximum Column Name Length: 30 Characters
- Maximum Row Size: 32677 Bytes (does not include LOB size)
ODBC (Client Versions 9.01.301.314 and 9.5.0.808)
- 32- and 64-bit: Fixed Numeric is transported as a CHAR, SQL_NUMERIC not supported.
OLEDB (Client Versions 9.01.301.314 and 9.5.0.808)
- 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.