what is the differences between spufi and qmf and which is
better?
Answers were Sorted based on User's Feedback
Answer / girish kumar
QMF - by using QMF we can execute 1 query at a time,
SPUFI - by using SPUFI we can exeute multiple querys at a time
QMF - By using QMF we can we can identify error code
SPUFI - BY using SPUFI we can identify error in case of
query failure,
application programmer use SPUFI.
I THINK SPUFI IS BETTER
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / girish kumar
QMF - by using QMF we can execute 1 query at a time,
SPUFI - by using SPUFI we can exeute multiple querys at a time
QMF - By using QMF we can not identify error code in case of
query fails.
SPUFI - BY using SPUFI we can identify error in case of
query failure,
application programmer use SPUFI.
I THINK SPUFI IS BETTER
| Is This Answer Correct ? | 1 Yes | 0 No |
Hi Hrushikesh
Can we get the location of error code usign QMF.
Vaneesh
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / hrushikesh
In SPUFI we cannot get the exact location of error only
error code is displayed.
In QMF we can get exact error codes.
So I can say for small queries one can use SPUFI
but for bigger ones we should use the QMF queries
| Is This Answer Correct ? | 1 Yes | 1 No |
Mention the location where the output received from explain statement is stored.
what is rebinding ?
why we create view.
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
what are extents?
How do I create a view in db2?
What are the various locking levels available?
What is the difference between Primary key and unique index?
what is the use of commit ? and what is the syntax?
How many buffer pools are there in DB2?
How does DB2 use multiple table indexes?
Why might full image copies be faster to implement than an incremental image copy?