Re: Union Views in Informix

"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