Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 4898 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
SELECT count(*) from SYSIBM.SYSTABLES
WHERE CREATOR = 'OWNER' ;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Mention the different locking levels that are available in db2.
How to restart a DB2 program?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the purpose of using commit?
How to test SQL -911 error while developing COB-DB2 program
What is db2?
What's The Percentage Free Space ?
What do you mean by cursor?
What does db2 plan contain?
What is alias in db2?
What is the physical storage length of the data types date, time, and timestamp?
What does db2 mean?
What is database manager in db2?
What is the use of dclgen in db2?
