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?
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
What is buffer pool?
Explain the function done by data manager?
Which is faster delete or truncate?
Define data page.
What's The Error Code For Unique Index Voilation?
How to execute stored procedures?
What is db2 bind?
What is the connection string to connect to the DB2 Database ?
What is the picture clause of null indicator variable?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
what is diffrence b/w file-aid tool and file-aid utility???
Why do we bind in db2?
What is sqlca’s maximum length?
List out the data types available.
How does db2 sample database connect?