docs.intersystems.com
InterSystems IRIS Data Platform 2019.2  /  Class Definition Reference

Class Definition Reference
ViewQuery
Previous section          
InterSystems: The power behind what matters   
Search:  


Specifies the SQL query for this class. Applies only to view definition classes.
Usage
To specify the SQL query for this class, use the following syntax:
ViewQuery = { statement }
Where statement is an SQL SELECT statement, enclosed in curly braces.
Details
When you define an SQL view (using the DDL CREATE VIEW statement or using the Management Portal), the system automatically creates a class definition to hold the view definition. For this class definition, ClassType is view, and ViewQuery equals the SQL statement on which the view is based.
This mechanism is internal; users are not expected to create view classes nor to modify the ViewQuery keyword. Instead, use the normal mechanisms (DDL or the Management Portal) for managing views.
This keyword is ignored for all non-view classes.
Default
The default value is an empty string.
See Also


Previous section          
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-08-16 05:50:13