Just You can use "any other query" and within this query you directly need to cast the 'Any other query' mode and type specifc INFORMIX types in types we can use. For example:
SELECT **(bsk_nummer::DECIMAL)** bsk_nummer FROM bsk_kopf
Anyways, I would be interesting to know why the SQL DB Config Editor can execute the statement by hand + map but the output DB step not!?
----
Casts with Informix SQL
http://stackoverflow.com/questions/178216/casting-in-informix
![alt text][1]![alt text][2]
[1]: http://answers.axonivy.com/upfiles/dbActivity_otherQuery.png
[2]: http://answers.axonivy.com/upfiles/dbActivity_mapFromRecord.png
