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 |
Which command is used to connect to a database in DB2 ? Give the Syntax.
WHAT IS MEANT BY COMMIT COMMAND?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
how to fetch multiple records without using cursor
What is the difference between plan and package in db2?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
What is view db2?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
What r the comman abends in db2, jcl and cobol???????
What is a bind in db2?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?