what is the differences between spufi and qmf and which is
better?

Answers were Sorted based on User's Feedback



what is the differences between spufi and qmf and which is better?..

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

what is the differences between spufi and qmf and which is better?..

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

what is the differences between spufi and qmf and which is better?..

Answer / vaneesh khurana

Hi Hrushikesh
Can we get the location of error code usign QMF.
Vaneesh

Is This Answer Correct ?    1 Yes 0 No

what is the differences between spufi and qmf and which is better?..

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

Post New Answer

More DB2 Interview Questions

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,


What is meant by the attachment facility?

3 Answers  


What is the purpose of the QUIESE Utility?

1 Answers  


How to find the maximum value in a column in the db2 database?

0 Answers  


What is bind plan?

0 Answers  






what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,


What is read-only cursor?

1 Answers  


What does DML stand for and what are some examples of it?

3 Answers   IBM,


what is + sign and -ve sign for sql code ?

1 Answers   TCS,


Explain in brief how does db2 determine what lock-size to use?

0 Answers  


Can you access the DB2 Directory table using SQL?

3 Answers  


What is load replace in db2?

0 Answers  


Categories