WHICH ONE IS BETTER EITHER SPUFI OR QMF?
- 5 Answers
- 11732 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hari
Hi
In QMF one can execute only one query at a time.But in
SPUFI you can execute multiple queries in sigle time.Only
thing is you need to seperate the queries using a semi
colon.
In QMF results can able to see in a report manner or output
will be in a format by pressing F9..
Hope this helps...
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / supreethi s
QMF also allows the output records to be stored in a
dataset by using the EXPORT command. SPUFI allows to view
the return codes for an SQL statement, can be used while
developing COBOL code. Whereas QMF is used for adhoc
reporting purposes.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / harish
As i know both SPUFI(sql processing using file input) and
QMF(query management facility) appears to be same,but in
QMF it will genartae report for related query
some companies they use SPUFI or QMF (advanced version)
Harish poomgame shivappa
NIIT Technolgies
Kolkata
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sanjay
One major advantage with SPUFI is that it allows you to
store the output in a dataset.
The processing time required by the either of tools depends
on the query path selected by the DB2 optimiser.
| Is This Answer Correct ? | 8 Yes | 3 No |
What are differences between QMF and SPUFI?
How to Clear a Query Using the RESET Command ?
How to view the Results of a Query?
How to Provide Column Names Using the DRAW Command ?
How to run a query using Run Query?
How to List the Available Tables?
How to Add Comments to a SQL Query?
WHICH ONE IS BETTER EITHER SPUFI OR QMF?
What is the Use SHOW Command?
how to excute a querry in QMF at a perticular time.
How to Save Your Profile?
How to Retriev and Display a Saved Query?
COBOL 
