https://answers.axonivy.com/questions/1788/problem-while-accessing-an-ibm-informix-db<p>I have connected an IBM Informix DB to my IVY Designer (6.1.0). Within the Database Configuration Editor I'm able to execute a simple query (see image 1).<img alt="alt text" src="http://answers.axonivy.com/upfiles/1.PNG"> But as soon I try to do the same within a database step (without mapping something to the Ivy DATA), I'll get an error (see image 2) <img alt="alt text" src="http://answers.axonivy.com/upfiles/2.PNG"> Does anybody has an idea how to fix it?</p>enWed, 01 Jun 2016 13:31:04 -0400https://answers.axonivy.com/questions/1788/problem-while-accessing-an-ibm-informix-db/1789<p>You can use "any other query" and within this query you directly need to cast the specifc INFORMIX types in types we can use. For example: SELECT <strong>(bsk_nummer::DECIMAL)</strong> bsk_nummer FROM bsk_kopf</p> <p>Anyways, I would be interesting to know why the DB Config Editor can execute the statement but the DB step not!?</p> <hr> <p>Casts with Informix SQL <a href="http://stackoverflow.com/questions/178216/casting-in-informix">http://stackoverflow.com/questions/178216/casting-in-informix</a></p> <p><img alt="alt text" src="http://answers.axonivy.com/upfiles/dbActivity_otherQuery.png"><img alt="alt text" src="http://answers.axonivy.com/upfiles/dbActivity_mapFromRecord.png"></p>Reguel WermelingerWed, 01 Jun 2016 13:31:04 -0400https://answers.axonivy.com/questions/1788/problem-while-accessing-an-ibm-informix-db/1789