Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

If the base table underlying a view is restructured, eg.
attributes are added, does the application code accessing
the view need to be redone?

Question Posted / guest

Answers were Sorted based on User's Feedback



If the base table underlying a view is restructured, eg. attributes are added, does the applicatio..

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

If the base table underlying a view is restructured, eg. attributes are added, does the applicatio..

Answer / 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

More DB2 Interview Questions

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

Give some example of statistics collected during RUNSTATS?

1 Answers  

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

what is cursor stability?

2 Answers   IBM,

What is cursor stability?

1 Answers  

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

What are the contents of dclgen?

0 Answers  

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

What is the purpose of the WHENEVER statement?

1 Answers  

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

What kind of database is db2?

0 Answers  

For more DB2 Interview Questions Click Here
Categories