How Plan is created while executing the query using SPUFI?
Answers were Sorted based on User's Feedback
Answer / guest
Plan is already created during the installation of the DB2I
tools.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / arun chinnadurai
A package/plan is created is created for DB2I tools and the
authorization to execute that plan is given to Public.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mangesh
No Plan is get created while executing the query using
SPUFI. SPUFI , QMF are only tools to check the correctness
of your query , i.e where ur query is correct or u have
coded anythig wrong .
| Is This Answer Correct ? | 6 Yes | 7 No |
What do you do to keep the cursor from closing after a commit?
How can you classify the locks in db2?
What is iseries database?
How do I delete a column in db2?
What's the difference between DB2 active log and archive log? Thanks a lot...
how to copy the host variables from ps file into cobol program other than include statement
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
How do you do the EXPLAIN of a dynamic SQL statement?
how can u retrieve the data from null values using applicaion program.
What is EXPLAIN?
What are the different types of base tables?
how to check the table is empty or not?