Hello Power BI users:
I have successfully connected to an Informix database but am encountering an error when I try to connect using the optional SQL statement.
My SQL statement contains a CASE expression like so:
SELECT ...
CASE
WHEN y.code IN(1,2,3) THEN "SUCCESSFUL"
WHEN y.code IN(4,5,6) THEN "UNSUCCESSFUL"
END AS status_result
The problem is that the Microsoft Informix Client interprets "SUCCESSFUL" in the above code as a column name and throws a -217 error saying that the "Column (SUCCESSFUL) not found in any table in the query (or SLV is undefined). SQLSTATE=IX000 SQLCODE=-217"
I can run this exact same code using the SQuirrel SQL client agains the Informix server and return a result.
If anyone has any idea of how to get around this error, or know if it is an error in the underlying Informix driver, I would love to hear from you.
Thanks!
