Once you create a view, where would information about the
view be stored?



Once you create a view, where would information about the view be stored?..

Answer / s

The CREATE statment is stored in the SYSIBM.SYSVIEWS

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

List out the three types of page locks that can be held.

0 Answers  


When Can you be sure that a query will return only one row?

4 Answers   IBM,


What is a db2 collection?

0 Answers  


What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,


How do you pull up a query which was previously saved in qmf?

0 Answers  






Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  


What is cascading rollback?

0 Answers  


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  


Define db2.

0 Answers  


What does runstats do in db2?

0 Answers  


select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  


What is the use of runstats in db2?

0 Answers  


Categories