Are views updatable ?
- 4 Answers
- 10722 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sadiq afroze
Not all of them. Some views are updatable e.g. single table
view with all the fields or mandatory fields. Examples of
non-updatable views are views which are joins, views that
contain aggregate functions (such as MIN), and views that
have GROUP BY clause.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / shankar
Yes but only for those views which are created with UPDATE
option.
| Is This Answer Correct ? | 5 Yes | 4 No |
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
What is check constraint. Explain with example.
what is dynamic cursor?gives syntax for this?
What is meant by explain?
how to resolve -805. give clear explination for that
Define declaration generator (dclgen).
How many types of page locks can be held in db2?
What happens in bind step in a db2 program?
Can I use LOCK TABLE on a view?
What is the difference between primary key & unique index ?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
Which component is used to execute the sql statements?
COBOL 
