wt is view ? wht r the restrictions for view ?
Answer Posted / ratheesh nellikkal
A view we can treat it as a virtual table.
It doesn't have any physical existance.
A View can be created entirely from a single table or from
a number of tables with appropriate joins.
The mail Restriction in a view is that if a view made up of
more than one table then it can not update it.
(Obviously if the base table is not exists the db2 will
trow an error and u can not create the view)
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How to find the maximum value in a column in the db2 database?
What is dbrm? When it will be created?
What is the difference between cursor and select statement?
What is iseries database?
What is a db2 tablespace?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Explain the contention situations caused by locks?
Name the lockable units in DB2?
Explain the benefits you can get from mainframe connect?
What does db2 plan contain?
Why db2 is called db2?
What is precompiler in db2?
i want to maintain uniqueness on pdf without make lf??????????
What is copy pending status in db2?
Is the primary key a clustered index?