Dear All,

I had been using IDS 9.3. I was able to create a view with UNION operation wherein I was selecting records from two different tables. It worked fine with IDS. But now when I port the same to Informix SE 7.24, it is not supported.

Is there any other alternative?

Hi,

Yes this is correct, this feature is even new in IDS 9.30 so all lower version like 7.31 and 9.21 would also not support this behavior. As far as I know there is also no workaround. I think you need to change your program logic.

Greetz,

Rob Prop