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?
- 3 Answers
- 6764 Views
- I also Faced
- E-Mail Answers
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 |
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
Explain in brief how does db2 determine what lock-size to use?
What does reorg do in db2?
Can one database have multiple instances?
What is meant by explain?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is consistency token in db2?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
what is the use of cursors?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is correlation names?
Give some example of statistics collected during RUNSTATS?
COBOL 
