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
- 6661 Views
- CTS, I also Faced
- E-Mail Answers
Answer / 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 |
What is RUNSTATS?
What types of tables are there in the db2 database?
What are the contents of a DCLGEN?
How to rename a table in DB2 ?
How would you print the output of an SQL statement from SPUFI?
What are some SQL aggregates and other built-in functions?
How do I import data from excel to db2?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
What does an outer join do?
how can i pull up a query which was previously stored in qmf
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
COBOL 
