What do you need to do before you do EXPLAIN ?
Answer / naveen87ginjupalli
The Plan_table is created under the AUTHID.
| Is This Answer Correct ? | 5 Yes | 0 No |
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
How to compare data between two tables in db2?
When would you prefer to use VARCHAR?
What is the difference between db2 and oracle?
What is correlated subquery?
If I have a view which is a join of two or more tables, can this view be updateable?
What does reorg do in db2?
how to execute qcmdexc in rpgle?plz write code also?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
what is Runstats? Whem will u choose to runatats?
What is a subselect? Is it different from a nested select?
What is the difference between Where and Having Clause