Skip to main content

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.