If the base table underlying a view is restructured, eg.
attributes are added, does the application code accessing
the view need to be redone?
Answer Posted / s
No, unless the new columns should be made part of the view,
the view needs to be regenerated.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to execute stored procedures?
What is db2 bind process?
Mention the location where the output received from explain statement is stored.
How to create db2 table in mainframe?
How to connect to db2 database from windows command line?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is a trigger in the db2 database?
what is utility for parm lib
How to check table size in db2 sap?
List down the types of triggers in the db2 database?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is sqlca?
Outputs of explain are with matchcols = 0. What does this signify?
Explain db2.
What is a bind in db2?