skip to main content
Designing and coding the IP : Views : Views in Dynamic Schema configuration : Create View
 

Create View

Query: CREATE VIEW V1 AS SELECT EMPID FROM emp
IP SCHEMA is called once for table, column, and statistics for each table in the view definition. Finally, IP SCHEMA is called with DAMOBJ_TYPE_TABLE for View itself to check for object name conflicts.
 
Table 13: Sequence of calls to schema to CREATE VIEW 
Call
Search Object – Damobj_Type
Object Name
Purpose
1
DAMOBJ_TYPE_TABLE
EMP
To validate view definition
2
DAMOBJ_TYPE_COLUMN
EMP
To obtain columns information
3
DAMOBJ_TYPE_STAT
EMP
To obtain index information
4
DAMOBJ_TYPE_TABLE
V1
To verify object name conflict