Interested to Buy Any Domain ? << Click Here >> for more details...
wt is view ? wht r the restrictions for view ?
- 3 Answers
- 7897 Views
- Verizon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / rajesh
View is just a display of a DB2 table where the access to
that view can be controlled.
Restriction : In order to create a view a base table should
exist.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / anjireddy vintha
view is a logical object which is derived from parent
table. view will be deleted automatically when patent table
is deleted.
| Is This Answer Correct ? | 0 Yes | 3 No |
What is dbrm? When it will be created?
How can the duplicate values be eliminated from db2 select?
What is the syntax for FETCH in DB2 ?
What is with ur in db2?
What is a subselect? Is it different from a nested select?
How do I connect my db2 database to ibm?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the syntax of SELECT statement when embedded in a COBOL program?
What is a collection?
What is a DBRM, PLAN ?
What are host variables in db2?
What are simple, segmented and partitioned table spaces ?
COBOL 
