wt is view ? wht r the restrictions for view ?
- 3 Answers
- 6587 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
Is ibm db2 free?
How to create db2 table in mainframe?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
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 ?
Where do you specify them?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is dbrm library?
What is dbrm? What it contains?
What is the difference between nvl and coalesce?
What is reorg?
How is deadlock resolved?
Name the lockable units in DB2?
What is a db2 collection?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
