About SPUFI AND QMF

sumanthmain · New User Joined: 22 Aug 2005 Posts: 14

hi from mates

Could u plz help me about this question.

Difference between SPUFI and QMF?? this is the interview question ?

Advance thanks

cheers
sumanth

vijayamadhuri · Active User Joined: 06 Apr 2005 Posts: 180

some of the features of qmf
Displaying a List of Database Objects
Viewing the Data in the Database Using Prompted Query
Viewing the Data in the Database Using SQL Statements
Customizing Your Reports
Displaying Your Report as a Chart
Creating a Procedure to Run QMF Commands
Creating Tables
Maintaining the Data in Your Tables
create reports with the data in u r tables
edit the data in u r tables

sumanthmain · New User Joined: 22 Aug 2005 Posts: 14

Thanks vijayamadhuri for ur prompt reply

I was asked exact differences.., like

what is the use of SPUFI over QMF?

Last answer was impressed me a lot..,

Thanks for ur answer.

cheers
sumanth

tam · New User Joined: 02 Nov 2005 Posts: 12 Location: zz

The biggest difference between QMF (Query management facility) and SPUFI (SQL Processing Using File Input) 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.

Keep in mind, though, that SPUFI comes for free with DB2 whereas QMF is an add-on product and costs money. Not every DB2 customer will have QMF, whereas every DB2 (mainframe) customer will have SPUFI.