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 |
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What are PACKAGES ?
What is meant by index cardinality?
What is the result of open cursor statement?
What is table space in db2?
Which one allows duplicate values Union or Union All ?
Can there be more than one cursor open for any program?
What is a lock?
What is cursor stability?
List out the buffer pools in db2
What is cursor?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?