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
What is meant by index cardinality?
What are the functions of Bind?
What DB2 Catalog column tell you when an index needs table reorganized ?
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?
What do you mean by storage group (stogroup)?
How does the processing of a correlated subquery differ from a non correlated subquery?
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?
what is the maximum number of tables that can be joined ?
wht is d/f between union and joins ?
Explain the benefits you can get from mainframe connect?
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.
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,