Forum Discussion

red_robot's avatar
red_robot
Frequent Visitor
8 years ago
Solved

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

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!

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

1 Reply

Replies have been turned off for this discussion
  • red_robot's avatar
    red_robot
    Frequent Visitor

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