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 is a db2 cursor?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is reorg in database?
Can you Average the Characters ?
How can you compare table column after update and before update?
What is a clustering index?
What will happen, while trying to close the closed cursor.
On the create tablespace, what does the CLOSE parameter do?
What is Reorg Recovery? when will you run it?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,