What are differences between QMF and SPUFI?
- 11 Answers
- 37621 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / balaganesan
QMF : We can excute single query at a time.
SPUFI : We can excute multiple queries at a time.
| Is This Answer Correct ? | 44 Yes | 5 No |
Answer / srini
The biggest difference between QMF and SPUFI is that QMF is
a query/reporting environment with the ability to format
reports. SPUFI is just a quick and dirty SQL execution
engine. If you need to produce nice looking reports, enable
user input to a query, or store your queries and reports
for future usage, QMF is a much better technology for doing
so.
| Is This Answer Correct ? | 22 Yes | 3 No |
Answer / sivakumar s
One added advantage is QMF avoids allocating Input/Output
Datasets to prevent from memory wastage.
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / sanjeev
hi
SPUFI :
1.you can execute more queries at a time.
2.you know the sqlcode after executing the query.
QMF:
1.you cannot execute more than one query.
2.you can't know the sqlcode of the query
| Is This Answer Correct ? | 17 Yes | 4 No |
Answer / prabhat
All the answers are correct.
To add on, QMF is mainfly used to generate nicely crafted
Reports with Headers, Footers for business users.
No one use QMF for dirty work while developing.
SPUFI is used beforehand to Optimise and validate Query
Results. QMF is later used to create reports out of the
query result
Query execution is much faster in QMF than the ones produced
by a COBOL,PL/1 or any High Level language program.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / rama krishna reddy
SPUFI IS BATCH EXECUTION OF DB2 QUERYS
QMF IS ONLINE APPLICATION
IN QMF WE CAN EXECUTE QUERY AT A TIME
BUT IN SPUFI WE CAN EXECUTE ANY NUMBER OF QUERYS
| Is This Answer Correct ? | 12 Yes | 7 No |
Answer / nagesh
Query Management Facility (QMF) AND SQL PROCESSING USING FILE INPUT (SPUFI), The main difference is QMF is one time report and by using SPUFI can execute multiple queries at the same time. We can also use QMF PROCEDURES FOR BATCH Process and believe, SPFUI do aswell. Inorder to save report in QMF, need to use 'EXPORT' command. In SPUFI, need to have two files one is for Input and other is for OUTPUT to save the results.
| Is This Answer Correct ? | 7 Yes | 2 No |
What is Query By Example (QBE) ?
How to Save Your Profile?
How to Provide Column Names Using the DRAW Command ?
What is Prompted Query?
How to Erase a Query?
What is qmf?
What is the use of ERROR Log ?
How many Query Options are there?
How to view the Results of a Query?
How to Display the Names of Your Saved Queries?
How to Create a Prompted Query?
How to execute a query in qmf at a particular time?
COBOL 
