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
- 6645 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
Is it possible using max on a char column?
How can you classify the locks in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How do we specify index to include or not during bind process.
What is the difference between dbm cfg and db cfg file in db2 ?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is alias in db2?
What is a collection in db2?
How can we read records for specific member in CL? AND rpg?
What is rct?
Where can you declare a cursor in a cobol-db2 program?
What is table space in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How can you find out the # of rows updated after an update statement?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
