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 |
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?
What is meant by the attachment facility?
What is the purpose of the QUIESE Utility?
How to find the maximum value in a column in the db2 database?
What is bind plan?
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?
What does DML stand for and what are some examples of it?
what is + sign and -ve sign for sql code ?
Explain in brief how does db2 determine what lock-size to use?
Can you access the DB2 Directory table using SQL?
What is load replace in db2?