WHICH ONE IS BETTER EITHER SPUFI OR QMF?
- 5 Answers
- 11352 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 is Query By Example (QBE) ?
What are Naming Conventions in QMF?
How to Build a Row Condition?
How to view the Results of a Query?
How to Add Comments to a SQL Query?
How the interaction between DB2, SQL, and QMF takes place?
How many types of queries does QMF offers?
What are differences between QMF and SPUFI?
What are Naming Standards in QMF?
What is the Use SHOW Command?
How to Clear a Query Using the RESET Command ?
How to Erase a Query?
COBOL 
