Create View with Union All Syntax error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Francis Teo Ee Cheok - 28 Apr 2004 03:22 GMT

Hi All ,

Can this syntax create view with union all work on SE?

THanks
FRancis
sending to informix-list

Reply to this Message

Art S. Kagel - 29 Apr 2004 13:10 GMT

> Hi All ,
>
> Can this syntax create view with union all work on SE?

No. VIEWs containing UNION clauses were first permitted in 7.31, since the
SE syntax parser is still at 7.2x level it does not permit this construct.

Art S. Kagel

Reply to this Message

Art S. Kagel - 29 Apr 2004 13:10 GMT

Oh, the solution is to use a stored procedure instead of a VIEW.

Art S. Kagel

> Hi All ,
>
[quoted text clipped - 3 lines]
> FRancis
> sending to informix-list

Reply to this Message