Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

About SPUFI AND QMF

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sumanthmain

New User


Joined: 22 Aug 2005
Posts: 14

PostPosted: Tue Oct 11, 2005 12:07 am    Post subject: About SPUFI AND QMF
Reply with quote

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
Back to top
View user's profile Send private message

vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Tue Oct 11, 2005 12:28 am    Post subject: Re: About SPUFI AND QMF
Reply with quote

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
Back to top
View user's profile Send private message
sumanthmain

New User


Joined: 22 Aug 2005
Posts: 14

PostPosted: Tue Oct 11, 2005 3:25 am    Post subject: Re: About SPUFI AND QMF
Reply with quote

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
Back to top
View user's profile Send private message
tam

New User


Joined: 02 Nov 2005
Posts: 12
Location: zz

PostPosted: Thu Nov 03, 2005 1:27 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problems in File-Aid / DB2 Spufi whil... amitc23 CLIST & REXX 6 Fri Feb 12, 2016 1:59 pm
No new posts Not able to access the DB2 via SPUFI sakthikumarT DB2 6 Sat Nov 28, 2015 1:52 am
No new posts DB2 program returned data is dif than... pradeepkit DB2 1 Tue Mar 03, 2015 5:39 am
No new posts How to skip foriegn Key constraint in... Arunkumar.chinnappa DB2 5 Fri Feb 07, 2014 2:17 pm
No new posts SPUFI => CSV Mike 1304 DB2 27 Tue Jan 21, 2014 10:06 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us