If the base table underlying a view is restructured, eg.
attributes are added, does the application code accessing
the view need to be redone?
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 |
what are stage one indexable predicates?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
Is ibm db2 free?
What are some characteristics of columns that benefit from indexes?
What is null indicator in db2?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What is QUIESCE?
What is usage pointer in cobol?
Explain what a plan is?
How can you display the current date & current time ?