Interested to Buy Any Domain ? << Click Here >> for more details...
wt is view ? wht r the restrictions for view ?
- 3 Answers
- 7794 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 |
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
if i made sme changes in sub pgm wht r the things to be done for this ?
What is a storage group (stogroup)?
How to get Top 10 Salaries from a Table
When do you specify the isolation level? How?
What is role in db2?
The only place of VSAM KSDS in DB2 is?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is lock escalation in db2?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What is tablespace?
What is database reorganization?
COBOL 
