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
 

 

Diffrance between SPUFI and QMF

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
krbabu

New User


Joined: 20 Feb 2004
Posts: 57

PostPosted: Mon Apr 26, 2004 12:47 pm    Post subject: Diffrance between SPUFI and QMF
Reply with quote

HI,
Can anybody tell about the what is the differance between QMF and SPUFI.
Back to top
View user's profile Send private message

G.P.Naidu

New User


Joined: 28 Apr 2004
Posts: 4
Location: delhi

PostPosted: Wed Apr 28, 2004 1:47 pm    Post subject:
Reply with quote

Hi,

In SPUFI result of the query will be in PS or in PDS member will store but
In QMF result of the query u can not store.

Thanks,
G.P.Naidu
Back to top
View user's profile Send private message
anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Wed Apr 28, 2004 2:32 pm    Post subject:
Reply with quote

hello krbabu,

The biggest difference between QMF and SPUFI 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.


Thanks,
Anu
Back to top
View user's profile Send private message
ksivapradeep

New User


Joined: 30 Jul 2004
Posts: 95

PostPosted: Wed Sep 15, 2004 9:52 am    Post subject:
Reply with quote

hi anu,

i studied in the book that qmf data will stored in external 'spill file' after executing the query cant we access that or view

regards

siva pradeep
Back to top
View user's profile Send private message
i413678
Currently Banned

Active User


Joined: 19 Feb 2005
Posts: 112
Location: chennai

PostPosted: Sat Feb 19, 2005 3:03 pm    Post subject: diff between SPUFI and QMF
Reply with quote

hi

SPUFI :

1.you can execute more queries at a time.
2.you know the sqlcode after executing the query.

QMF:
1.you cannot execute more than one query.
2.you can't know the sqlcode of the query.


Regards,
Pavan
Back to top
View user's profile Send private message
munnamgi

New User


Joined: 27 Feb 2006
Posts: 1

PostPosted: Thu Mar 29, 2007 10:50 pm    Post subject:
Reply with quote

Hi,

Pls do TSO QMFALLOC after query is executed in QMF.

Then press PF4

It will spool the data into MainframeuserID.QMFRPT file.

Pls check if this work with your system
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 -> Mainframe Interview Questions 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