Answer Posted / 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 |
Post New Answer View All Answers
How to Create a Prompted Query?
How to Clear a Query Using the RESET Command ?
How to Save a Query?
What is qmf?
How to List the Available Tables?
How to execute a query in qmf at a particular time?
How to Build a Row Condition?
What are Naming Conventions in QMF?
How the interaction between DB2, SQL, and QMF takes place?
How to Provide Column Names Using the DRAW Command ?
What are Naming Standards in QMF?
How to Get Information About the Tables?