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
- 4895 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish
select count(*) from sysibm.systables where creator='owner'
select * from sysibm.systables
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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.
What does sqlcabc has?
What is cursor stability in db2?
What is bind and rebind in db2?
What is phantom read in db2?
What is the use of db2 optimizer?
What is a buffer in memory?
What is the reason behind not using select * in embedded sql programs?
What is the maximum length of sqlca?
What is page size in db2?
What is the function of logging in the db2 database?
What is bind plan?
What is a db2 package?
What is difference between alias and synonym in db2?
What is the difference between db2 and oracle?
