Can we able to find all the Table names under a Particular
Plan?
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 COPY PENDING status?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is the picture clause of null indicator variable?
What is explain in db2?
What is the logical entity between plan and Package?
What is deadlock?
Where is the output of EXPLAIN stored?
if i made sme changes in sub pgm wht r the things to be done for this ?
wht is d/f between union and joins ?
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
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?