what is the differences between spufi and qmf and which is
better?
- 4 Answers
- 10480 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 is copy book?
Is ibm db2 open source?
Explain how can you do the explain of a dynamic sql statement?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
When DB2 connection fails, will online program work or give errors.
List down the data types in the db2 database.
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How can you split a table in to exactly half?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How many Buffer pools are there in DB2 and what are they?
What is rct?
what is check point and restart Logic ? why do we go for that ??
COBOL 
