Alteryx Designer Discussions

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

Input Data (33) Error SQLExtendedFetch: [IBM][CLI Driver][DB2/AIX64] SQL0420N

leahhill
5 - Atom

Hello, 

 

I am trying to connect to an ODBC database file input, and am receiving the following error:  Input Data (33) Error SQLExtendedFetch: [IBM][CLI Driver][DB2/AIX64] SQL0420N Invalid character found in a character string argument of the function "DECFLOAT". SQLSTATE=22018 ¶

 

I am connecting to this database, but a different table, successfully in the same workflow. I have searched for parts of this error and found nothing. Has anyone seen this/ know what this is referencing?

 

Thank you,

 

Leah Hill 

2 REPLIES 2
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

This is a SQL error being generated by the database.

It typically means that you either:

a. Are querying a string value stored as a number but have unnecessary quote marks around the number.

Or

b. Are querying a number being stored as a string and don't have quote marks around the number.

Or

c. Are attempting to join two fields where one is a number and one is a string.

 

Mark_Marshall
5 - Atom

This was very useful for me. Thank you so much!

Labels