Interested to Buy Any Domain ? << Click Here >> for more details...
Can we able to find all the Table names under a Particular
Plan?
- 1 Answers
- 6764 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / vat
Absolutely! Just look at the catalog table SYSIBM.SYSPLANDEP
It's pretty straight forward! It recrods the dependencies
of plans on tables, views, synonyms, table spaces, indexes,
aliases, functions and stored procedures.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is the meaning concurrency in the db2 database?
What is release/acquire in bind?
How many databases can be created inside an instance in db2 ?
What is buffer pool?
What are iseries servers?
How do you select a row using indexes in db2?
What does runstats do in db2?
Which isolation level provides highest data integrity?
What do you mean by between and in? Is between inclusive of specified range values?
Before you give the explain statement, what are the prerogatives?
What is view db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is the purpose of using commit?
What is the difference between cursor and select statement?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
