skip to main content
Designing and coding the IP : Views : Views in Dynamic Schema configuration : Select From view
 

Select From view

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).
 
Table 14: 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