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 is the cobol picture clause of the db2 data types date, time, timestamp?
What is the information associated with sysibm.syslinks table?
What is coalesce in db2?
Discuss about db2 bind?
Mention data types used in db2 ?
What is reorg and runstats in db2?
What are packages in db2?
how will you retrieve first record in table
what is datacom db?
What is the physical storage length of time data type?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
cobol-db2 runjcl please?