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

why we go for SPUFI for creating tables or for sql queries?

4 Answers  


What is scrollable cursor in db2?

0 Answers  


Can any one tell me about Restart logic in DB2.

2 Answers  


Can you search give an array in the WHERE clause of a db2 query?

1 Answers  


What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,


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  


explain about index with examples

2 Answers   Syntel,


How to see the structure of db2 table??

4 Answers   IBM,


How can you split a table in to exactly half?

7 Answers   HSBC,


How to design maps

1 Answers   Virtusa,


How will you return the number of records in table?

0 Answers  


pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


Categories