Interested to Buy Any Domain ? << Click Here >> for more details...
wt is view ? wht r the restrictions for view ?
- 3 Answers
- 7791 Views
- Verizon, I also Faced
- E-Mail Answers
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
What is the purpose of using commit?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the use of commit in db2?
Define db2 and its databases?
What r the comman abends in db2, jcl and cobol???????
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Which is faster delete or truncate?
When do you specify the isolation level?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
List down the types of triggers in the db2 database?
What is a collection in db2?
Explain what are the various isolation levels possible?
what is diffrence b/w file-aid tool and file-aid utility???
Is db2 relational database?
What is host variable?
