Interested to Buy Any Domain ? << Click Here >> for more details...
wt is view ? wht r the restrictions for view ?
- 3 Answers
- 7740 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 |
can all users have the privilage to use the sql statement select * (dml)?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
cobol-db2 runjcl please?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What is buffer pool in the db2 database?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
What do you mean by cursor?
Which component is used to execute the sql statements?
How many Buffer pools are there in DB2 and what are they?
How do I import data from excel to db2?
Can we insert update delete in view?
COBOL 
