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?
Answers were Sorted based on User's Feedback
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 |
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 |
What is pagespace?
What are bind parameters in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How would one remove old reorg information from the DB2 catalog?
What is cursor in dbms?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
How is deadlock resolved?
what is the use of commit ? and what is the syntax?
What is auditing?
What is the usage of open cursor command?
what are stage one indexable predicates?
What's the maximum number of volumes that can be added to a STOGROUP?