EA 11.2 | Create View Statement

Developing Portable Applications > Developing Portable Applications > Application Considerations > Implementation Differences > Create View Statement

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: 08/22/2022