"Art S. Kagel" wrote:
>
> OK, it has been a while, but now I have a question for the community.
>
> IDS 7.21UD3 and IDS 7.24UC7
>
> Now on 7.30UC3 I CAN create the view and use it in the subquery but
> I still cannot use the UNION in the subquery itself. Very odd! Any
> ideas team?
And just to top off all the valid responses, the use of UNION in views
was one of the new features introduced in version 7.30.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com http://www.informix.com/idn |///// / //|
|http://www.iiug.org +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+