Problem while accessing an IBM Informix DB

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

informix sql

asked 01.06.2016 at 10:51

peter_muc
(suspended)
accept rate: 0%

edited 01.06.2016 at 16:46

Reguel Werme... ♦♦
9.4k●3●19●58

One Answer:

active answers oldest newest most voted

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 text

link

This answer is marked "community wiki".

answered 01.06.2016 at 13:31

Reguel Werme... ♦♦
9.4k●3●19●58
accept rate: 70%

edited 01.06.2016 at 16:51

SupportIvyTeam ♦♦
1.4k●102●118●122

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Tags:

sql ×3
informix ×1

Asked: 01.06.2016 at 10:51

Seen: 1,932 times

Last updated: 01.06.2016 at 16:51

Problem while accessing an IBM Informix DB

Follow this question

Related questions