Was this helpful?
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.
Last modified date: 02/16/2024