Interested to Buy Any Domain ? << Click Here >> for more details...
How Plan is created while executing the query using SPUFI?
- 3 Answers
- 8639 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 |
When can an insert of a new primary key value threaten referential integrity?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What techniques will be used to avoid deadlock??
What is DB2 (IBM Database 2)?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What are types of indexes?
Can we delete records from view?
What is UNION,UNION ALL?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
B37 abend during spufi?
What is dclgen in db2?
On which levels locks can be applied?
COBOL 
