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). 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) Does anybody has an idea how to fix it? asked 01.06.2016 at 10:51 peter_muc Reguel Werme... ♦♦ |
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 (bsk_nummer::DECIMAL) bsk_nummer FROM bsk_kopf Anyways, I would be interesting to know why the DB Config Editor can execute the statement but the DB step not!? Casts with Informix SQL http://stackoverflow.com/questions/178216/casting-in-informix
link
This answer is marked "community wiki".
answered 01.06.2016 at 13:31 Reguel Werme... ♦♦ SupportIvyTeam ♦♦ |
Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
Tags:
Asked: 01.06.2016 at 10:51
Seen: 2,016 times
Last updated: 01.06.2016 at 16:51