If the base table underlying a view is restructured, eg.
attributes are added, does the application code accessing
the view need to be redone?
- 2 Answers
- 4666 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / s
No, unless the application pgm needs to take advantage of
the new columns.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you check for a null value in a db2 column?
What is a DB2 bind?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
Update command
What is a subselect? Is it different from a nested select?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
Can a Db2 table data be retrived through JCL?
What are the prerogatives?
How to resolve -805 error in DB2?
is it possible to get -811 error when you use cursors. why?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
COBOL 
