What are differences between QMF and SPUFI?
- 11 Answers
- 36868 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 the Use SHOW Command?
What is the purpose of RUN Command?
How to Add Comments to a SQL Query?
How to Get Information About the Tables?
How the interaction between DB2, SQL, and QMF takes place?
How to Provide Column Names Using the DRAW Command ?
How to Display the Names of Your Saved Queries?
What is qmf?
How to run a query using Run Query?
HOW TO COMMENT THE QMF QUERIES?
WHICH ONE IS BETTER EITHER SPUFI OR QMF?
What are Naming Standards in QMF?
COBOL 
