IBM DB2

Version:
2019.3
Last modified: September 26, 2019
Connection Type

ODBC and OLEDB (32- and 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.

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.