Once you create a view, where would information about the
view be stored?
List out the three types of page locks that can be held.
When Can you be sure that a query will return only one row?
What is a db2 collection?
What techniques will be used to avoid deadlock??
How do you pull up a query which was previously saved in qmf?
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
What is cascading rollback?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
Define db2.
What does runstats do in db2?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
What is the use of runstats in db2?