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

9.5.0, 10.5

Alteryx Tools Used to Connect

Standard Workflow Processing

Input Data Tool

Input Data Tool Icon

Link

Output Data Tool

Output Data Tool Icon

Link

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.