Interested to Buy Any Domain ? << Click Here >> for more details...
Are views updatable ?
- 4 Answers
- 12824 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 |
What's the difference between DB2 active log and archive log? Thanks a lot...
What is a result table?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
where will u check for sqlcode ?
What is the cascade rule and how does it relate to deletions made with a subselect?
When is the results table for the query in a DECLARE CURSOR statement created?
what is a trigger and types of triggers
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
What does it mean if the null indicator has -1, 0, -2?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
What is ibm db2 used for?
COBOL 
