Select From view
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
Query: SELECT * FROM V1
IP SCHEMA is called on the View object with type DAMOBJ_TYPE_TABLE. Once the view is translated to base table query, IP SCHEMA is called again for each of the base tables (for Table, Column and Statistics information).
Sequence of calls to SCHEMA to execute a query containing a view
| Call | Search Object – Damobj_Type | Object Name | Purpose |
| 1 | DAMOBJ_TYPE_TABLE | V1 | To check whether the search is on Table reference or View |
| 2 | DAMOBJ_TYPE_TABLE | EMP | To validate the query part of the view definition |
| 3 | DAMOBJ_TYPE_COLUMN | EMP | To obtain column information |
| 4 | DAMOBJ_TYPE_STAT | EMP | To obtain index information |