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
- 5082 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 to know the primary key of a table without defining the primary key in the table?
pls tell me abt the normalization five types....
Which command is used to connect to a database in DB2 ? Give the Syntax.
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
Mention the different locking levels that are available in db2.
How is deadlock resolved?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
Explain package in db2 and its advantages?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is the maximum size of a char data type in db2?
what is the difference between where clause and having clause
Q4. How will you get the count of record without using COUNT verb in query?
COBOL 
