I need to view the number of tables existing under one
particular Owner. Is it possible? If so, pl give the SQL
query for this?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is meant by index cardinality?

2 Answers  


What are the functions of Bind?

2 Answers   Amdocs, IBM,


What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  


What do you mean by storage group (stogroup)?

0 Answers  






How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  


Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,


what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,


wht is d/f between union and joins ?

2 Answers  


Explain the benefits you can get from mainframe connect?

0 Answers  


I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,


what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,


Categories