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

peter_muc
29111115
accept rate: 0%

edited 01.06.2016 at 16:46

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
7.8k11549


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

link
This answer is marked "community wiki".

answered 01.06.2016 at 13:31

Reguel%20Wermelinger's gravatar image

Reguel Werme... ♦♦
7.8k11549
accept rate: 69%

edited 01.06.2016 at 16:51

SupportIvyTeam's gravatar image

SupportIvyTeam ♦♦
1.2k71101109

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

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

Tags:

×3
×1

Asked: 01.06.2016 at 10:51

Seen: 702 times

Last updated: 01.06.2016 at 16:51