Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5147 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 |
What is a lock?
how to take the back up of the DB2 table.
Explain about dbrm.
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.
How do I add a column to an existing table in db2?
What is DCLGEN?
What are the three lock types?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What types of tables are there in the db2 database?
What do you mean by NOT NULL? When will you use it?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
COBOL 
