ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Designer Returns Null Value for a Column of Date Datatype in a DB2 Database

JLinAltX
Alteryx
Alteryx
Created

Environment Details


When connecting to a DB2 Database via ODBC in Designer, some Date datatype from a column is coming up Null when viewing from the Results panel.


 

  • Alteryx Designer
    • Version 2019.4+


Cause


Potential DB2 ODBC driver issue.

Resolution


1. Validate the DB2 ODBC Driver is the correct version:
  • The supported DB2 ODBC drivers are in the Help Documentation.
  • If you are using a different DB2 ODBC version, you want to make sure you try with the officially tested versions.

2. Validate using a different application:
  • If the officially tested DB2 ODBC versions are still showing the same issue, use a different application to connect to your DB2 database with the same ODBC driver and see if the problem persists.  
  • If there is no problem from the other application with the supported DB2 ODBC drivers, contact Alteryx Support for help.