How Plan is created while executing the query using SPUFI?
- 3 Answers
- 7908 Views
- I also Faced
- E-Mail Answers
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 are the benefits of using the db2 database?
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. TIA
what is parm utility
What is query_cache_limit?
What do you mean by rollback?
what are the bind parameters?
How does cobol compile db2 program?
What is a cursor?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is db2 catalog database?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What is the use of value function?
COBOL 
