Diffrance between SPUFI and QMF

krbabu · New User Joined: 20 Feb 2004 Posts: 57

HI,
Can anybody tell about the what is the differance between QMF and SPUFI.

G.P.Naidu · New User Joined: 28 Apr 2004 Posts: 4 Location: delhi

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

anuradha · Posted: Wed Apr 28, 2004 2:32 pm

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

ksivapradeep · New User Joined: 30 Jul 2004 Posts: 95

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

i413678 · Posted: Sat Feb 19, 2005 3:03 pm

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

munnamgi · New User Joined: 27 Feb 2006 Posts: 1

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