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... ♦♦
8.5k21851


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... ♦♦
8.5k21851
accept rate: 69%

edited 01.06.2016 at 16:51

SupportIvyTeam's gravatar image

SupportIvyTeam ♦♦
1.3k90110118

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: 844 times

Last updated: 01.06.2016 at 16:51