SqlViewName
Usage
To override the default name used when the query is projected as an SQL view, use the following syntax:
Query name(formal_spec) As classname [ SqlView, SqlViewName = "_Q1" ] { //implementation }
Where sqlviewname is an SQL identifier.
Details
This keyword provides an SQL alias for the view projected from this query.
Default
If you omit this keyword, the SQL view name is the query name.
See Also
-
“Query Definitions” in this book
-
“Defining and Using Class Queries” in Using Caché Objects
-
“Introduction to Compiler Keywords” in Using Caché Objects