IBM DB2

Type of Support: Read & Write
Validated On: 9.5.0, 10.5
Connection Type: ODBC and OLEDB (32- and 64-bit)
Driver Details: The ODBC or OLEDB driver can be downloaded from IBM DB2.

Alteryx tools used to connect

Input Data Tool and Output Data Tool (For 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.