Interested to Buy Any Domain ? << Click Here >> for more details...
what is the differences between spufi and qmf and which is
better?
- 4 Answers
- 11931 Views
- Accenture, Cap Gemini, I also Faced
- E-Mail Answers
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 |
What DB2 Catalog column tell you when an index needs table reorganized ?
is there any restrictions for unions ?
how to resolve -811 sqlcode .give clear explaination
What is db2 instance?
What is the use of value function?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
My SQL is not performing well. Describe how will you fine tune it?
how to unload different table data into different gdg files/ vsam files.
What db2 400?
what happend with out using Commit,when closing cursor and program?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
Which is faster delete or truncate?
COBOL 
