wt is view ? wht r the restrictions for view ?
- 3 Answers
- 6892 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 happens in bind step in a db2 program?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
What is catalog database in db2?
What is access path in db2?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
On the create tablespace, what does the CLOSE parameter do?
What is a synonym? How is it used?
how to u check the query is executing or not ?where will u check for sqlcode ?
is it possible to get -811 error when you use cursors. why?
What is the SQL Communications Area and what are some of its key fields?
is it compulsory commitment control in journal?
what happend with out using Commit,when closing cursor and program?
COBOL 
