Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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?

Question Posted / s

Answer Posted / s

do a select on SYSIBM.SYSTABLES

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does a cursor work?

926

What is dbrm library?

996

What are the various data types available in db2?

1011

What is the use of db2?

1002

How can you count the number of rows from a table tab?

1038

What is the information associated with sysibm.syslinks table?

1055

How to find the maximum value in a column in the db2 database?

1014

What is query_cache_limit?

927

What is dclgen (declaration generator)?

1009

Which isolation level provides highest data integrity?

1038

List out the buffer pools in db2

1018

What do you mean by storage group (stogroup)?

984

How to find primary key of a table in db2?

1001

On which levels locks can be applied?

1059

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2007