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 |
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
Why do we bind in db2?
How can you classify the locks in db2?
What is a collection in db2?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
How do I change the column size in db2?
Can SQL statements/queries be included in a copybook?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Which catalog tables contain authorization information?
wht steps we need will coding cobol and db2 pgm ?
Who uses db2?
what is load and unload in db2