Interested to Buy Any Domain ? << Click Here >> for more details...
wt is view ? wht r the restrictions for view ?
- 3 Answers
- 7891 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 |
How can record locking be achieved in those DB2 versions which do not support it?
How do you Load a table ?? and what is Load replace ?
What is the syntax of SELECT statement when embedded in a COBOL program?
Can you Average the Characters ?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
how can u understand the end of the table ?
What technique is used to retrieve data from more than one table in a single SQL statement?
What is sqlca’s maximum length?
What are the 2 sqlcodes that are returned?
B37 abend during spufi?
What is a Database Request Module(DBRM)?
What is the use of db2 optimizer?
COBOL 
