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 / s
SELECT count(*) from SYSIBM.SYSTABLES
WHERE CREATOR = 'OWNER' ;
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are host variables in db2?
What is catalog database in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
When reorg is used?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Which isolation level provides highest data integrity?
what is diffrence b/w file-aid tool and file-aid utility???
Explain in detail about buffer manager and its functionalities?
How to view db2 table structure?
What is db2?
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 check constraint. Explain with example.
What do you mean by commit and rollback?
Mention the various locks that are available in db2.
Explain how can you do the explain of a dynamic sql statement?