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