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

What is commit in db2?

0 Answers  

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

0 Answers  

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

0 Answers  

What is the physical storage length of time data type?

0 Answers  

List some fields from sqlca?

0 Answers  

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 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,

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  

What is role in db2?

0 Answers  

How can you split a table in to exactly half?

7 Answers   HSBC,

For more DB2 Interview Questions Click Here
Categories