If I have a view which is a join of two or more tables, can
this view be updatable?
Answer Posted / guest
If view has join that time view can not be updatable.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can the duplicate values be eliminated from db2 select?
What do you mean by storage group (stogroup)?
How can you count the number of rows from a table tab?
When reorg is used?
How does cobol compile db2 program?
What is a bind card?
Define predicate?
What are foreign keys in db2?
Highlight all the advantages that are attached to a package.
What is the maximum length of sqlca?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What action db2 takes when a program aborts in the middle of a transaction?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Differentiate between cs and rr isolation levels? Where do you specify them?
How do you pull up a query which was previously saved in qmf?