What do you need to do before you do EXPLAIN?
Answer / s
Create the Plan_table to holds the results of the explain.
| Is This Answer Correct ? | 5 Yes | 0 No |
What r the comman abends in db2, jcl and cobol???????
Can we update view in db2?
What is an asychronous write?
What is the use of runstats in db2?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
can any body explain about plan and pakage in detail....
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is database reorganization?
What is a data page?
On which levels locks can be applied?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?