Skip to main content

[en] IBM DB2

[en] Connection Type

[en] ODBC and OLEDB (64-bit)

[en] Driver Details

[en] The ODBC or OLEDB driver can be downloaded from IBM DB2.

[en] Type of Support

[en] Read & Write

[en] Validated On

9.5.0, 10.5

[en] Alteryx Tools Used to Connect

[en] Standard Workflow Processing

[en] Input Data Tool

Input Data Tool Icon

[en] Link

[en] Output Data Tool

Output Data Tool Icon

[en] Link

[en] Additional Details

[en] OLEDB has issues with NULL vs. Empty in some cases. Use ODBC.

[en] Limitations

[en] Database Version: 10.5

  • [en] Maximum Columns in Table: 1012

  • [en] Maximum Column Name Length: 128 Characters

  • [en] Maximum Row Size: 32677 Bytes (does not include LOB size)

[en] Database Version: 9.5.0

  • [en] Maximum Columns In Table: 1012

  • [en] Maximum Column Name Length: 30 Characters

  • [en] Maximum Row Size: 32677 Bytes (does not include LOB size)

[en] ODBC (Client Versions 9.01.301.314 and 9.5.0.808)

  • [en] 32- and 64-bit: Fixed Numeric is transported as a CHAR, SQL_NUMERIC not supported.

[en] OLEDB (Client Versions 9.01.301.314 and 9.5.0.808)

  • [en] 32-bit: No Issues

  • [en] 64 bit: Version: 9.01.301.314 (differences between NULL and EMPTY)

  • [en] 64 bit: Version: 9.5.0.808 (only BLOB and VString seem to work)

[en] Known Issues

[en] A single workflow with ODBC connections cannot contain OleDB connections using the same driver.

: