Interested to Buy Any Domain ? << Click Here >> for more details...
wt is view ? wht r the restrictions for view ?
- 3 Answers
- 7603 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 does db2 plan contain?
What is the physical storage length of time data type?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is DB2 (IBM Database 2)?
What is UNION,UNION ALL?
What is the logical entity between plan and Package?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is a DB2 catalog?
What parameters are used to control the free space in DB2?
COBOL 
