Connecting to Informix server with SQL statement - CASE expression returns "column not found" error

[red_robot]

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!

[red_robot · Accepted solution]

Nevermind ... I replaced all double quotes with single quotes and it appears to have fixed the error. Thanks!