Create View Statement
The create view statement has the following restrictions:
• create view with select joined by the union clause is not allowed:
create view xxx
as
(
select ...
UNION
select ...
)
• Microsoft SQL Server and Oracle do not allow create view with the USER constant:
create view tab1 (user_name)
as
select USER
When either command is executed, the gateway returns sqlcode E_GX0204 (syntax error). The first statement fails for the same reason if submitted through Ingres Distributed Option.