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 / guest

Answers were Sorted based on User's Feedback



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

Answer / nitesh

SELECT TABNAME FROM SYSCAT.TABLES WHERE OWNER='<ownername>

eg. SELECT TABNAME FROM SYSCAT.TABLES WHERE OWNER='NITESH'

Is This Answer Correct ?    2 Yes 1 No

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

Answer / s

do a select on SYSIBM.SYSTABLES

Is This Answer Correct ?    1 Yes 1 No

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

Answer / shankar

Select TBNAME from SYSIBM.SYSTABLES where TBOWNER = ' '

- Try 'NAME' and 'OWNER' if TB prefix does not work.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

where can we use index and subscript ? with example ?

3 Answers   CTS,

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

What is the maximum size of varchar data type in db2?

0 Answers  

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

What are the contents of a dclmgen?

0 Answers  

why we create view.

5 Answers  

What else is there in the PLAN apart from the access path?

1 Answers  

What do you mean by storage group (stogroup)?

0 Answers  

What are packages in db2?

0 Answers  

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

For more DB2 Interview Questions Click Here
Categories