Interested to Buy Any Domain ? << Click Here >> for more details...
How Plan is created while executing the query using SPUFI?
- 3 Answers
- 8749 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 is a Cartesian product?
Explain the contention situations caused by locks?
How would you print the output of an SQL statement from SPUFI?
Can we install 2 different versions of Db2 on same mainframe?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What is ibm db2 connect?
what is SPUFI ?
How does coalesce work?
What are host variables in db2?
Can any one tell me about Restart logic in DB2.
What is an access path?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
COBOL 
