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).alt text 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) alt text Does anybody has an idea how to fix it?

asked 01.06.2016 at 10:51

peter_muc's gravatar image

accept rate: 0%

edited 01.06.2016 at 16:46

Reguel%20Wermelinger's gravatar image

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

alt textalt text

This answer is marked "community wiki".

answered 01.06.2016 at 13:31

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
accept rate: 70%

edited 01.06.2016 at 16:51

SupportIvyTeam's gravatar image

SupportIvyTeam ♦♦

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 01.06.2016 at 10:51

Seen: 1,128 times

Last updated: 01.06.2016 at 16:51