Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Alteryx date data type error trying to create Informix ODBC datetime

Alteryx Certified Partner



I am using ODBC - Informix for table creation in Informix. The date columns ODBC converts to datetime, so a Informix syntax error occurs.
The datetime type in Informix has a different syntax for creating the column with this data type.
Someone has already encountered this problem and managed to resolve to generate string type.








Alteryx Certified Partner
Alteryx Certified Partner

Hi @geraldo 


Maybe it's because you're using "CREATE" as your column name, and "CREATE" is one of the reserved key words that can't be used.


Try to change your field name to something else.



Alteryx Certified Partner

Hi, @Thableaus



The problem is not this, I am passing a field type date and ODBC transforms to datetime and in Informix the syntax for datetime cannot be just datetime.


Informix datetime type creation example:


createdate datetime year to day
createdate datetime hour to minute
createdate datetime year to fraction(5..0) 


and more others



Alteryx Certified Partner
Alteryx Certified Partner



That's weird. I don't think this should've been a problem at all, since you can't change this syntax in Alteryx (the syntax is automatically created by the ODBC driver).