Interested to Buy Any Domain ? << Click Here >> for more details...
wt is view ? wht r the restrictions for view ?
- 3 Answers
- 7604 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
How do you concatenate the firstname and lastname from emp table to give a complete name?
How to restart a DB2 program?
Explain the benefits you can get from mainframe connect?
How can the duplicate values be eliminated from db2 select?
What is a db2 table?
What is the use of predicate?
What r the comman abends in db2, jcl and cobol???????
What is db2 look?
What is the default page size of buffer pools?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Can we delete records from view?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Explain the function done by data manager?
Explain about open switch business continuity software?
What is the connection string to connect to the DB2 Database ?
