community
cancel
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

Hi, 

 

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.

 

clipboard_image_0.png

 

clipboard_image_1.png

 

 

 

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.

 

Cheers, 

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

 

Thanks!!

Alteryx Certified Partner
Alteryx Certified Partner

@geraldo 

 

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).

 

Cheers,

Labels