Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

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

JLinAltX
Alteryx
Alteryx
Created

‎11-05-2020 02:29 PM - edited ‎07-22-2021 12:43 PM

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.
0 Likes
Labels