Re: Union Views in Informix
Posted in 1999
Topics: Versions, Editions & End-of-Life
"Union views" are supported in the IDS 7.3 product, and will be in
the extensible version 9.2 when it is released this summer.
The only workaround I know of is to alter the SQL. :(
Clem
At 07:52 PM 20-01-99 GMT, mikedw@my-dejanews.com wrote:
>I'm porting an Illustra app to Informix Universal Server and the Illustra
>application has a number of union views:
>
>i.e.
>
>create view xxx (....) as>select .... where ....
>union
>select .... where ....;
>
>In Informix it is not possible to code such a view (containing a union
>operator). Has anyone found a general workaround to this problem?
>
>Many thanks,..
>Mike Dunham-Wilkie
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
_______________________________________________________________
Clem Akins (aka clem@informix.com) Menlo Park x5937
Customer Course Development Informix Software, Inc
Last seen: Thrilled by "Amadeus" in Mountain View, CA, USA