If the base table underlying a view is restructured, eg.
attributes are added, does the application code accessing
the view need to be redone?
Answer Posted / s
No, unless the application pgm needs to take advantage of
the new columns.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between using bind () and rebind () methods of naming class?
Explain correlated sub-queries.
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
Can you tell me how can you find out the # of rows updated after an update statement?
What do you mean by cursor?
Explain about rct.
Is db2 relational database?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Why do chiropractors use drop table?
Why db2 is called db2?
What are the various isolation levels possible?
What is the function of logging in the db2 database?
What is copy pending status in db2?