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
- 6660 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 do you mean by commit and rollback?
What is the role of schema in the db2 database?
What is the difference between cursor and select statement?
What is syscat in db2?
Explain the benefits you can get from mainframe connect?
What is runstats and reorg in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the use of db2 optimizer?
What is declare cursor?
How do I delete a table in database?
Why do we use cursor?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is a collection in db2?
Is db2 a programming language?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
