Are views updatable ?

Answer Posted / shankar

Yes but only for those views which are created with UPDATE
option.

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1806


List down the types of triggers in the db2 database?

590


Is db2 a mainframe?

588


How can we read records for specific member in CL? AND rpg?

233


Define declaration generator (dclgen).

667






Mention some fields that are a part of sqlca.

603


What is database reorganization?

589


What is ibm db2 connect?

573


What does db2 blu stand for?

660


What is the use of with ur in db2?

615


What is the difference between plan and package in db2?

574


How can you quickly find out the # of rows updated after an update statement?

632


What is null indicator in db2?

603


What do you mean by cursor?

586


How do I optimize a query in db2?

622