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 |
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
What is a cursor and what is its function?
What is reorg in DB2
What are union and union all?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
Explain packages.
why we go for SPUFI for creating tables or for sql queries?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is db2 stogroup?
What is the error code -803 ?
What is a root page?
select distinct(empid),distinct(dept),name from EMP will the above query work?