What is the differance b/w using SPUFI and QMF.

Praveen Kumar Singh · New User Joined: 02 Jan 2007 Posts: 6 Location: Mumbai

Tell me which is better of the two and why?

Praveen Kumar Singh · New User Joined: 02 Jan 2007 Posts: 6 Location: Mumbai

What is the differance b/w using SPUFI and QMF?

Warning: Do not Repost

wanderer · Posted: Fri Feb 23, 2007 6:58 am

They are two different tools and there is nothing like better one among them.

QMF is cometimes used for generating reports and formating them whereas SPUFI is just a quick and fast way to run some SQL.

QMF has some nice functions that are available using PF keys (see bottom of QMF screen) that are handy.

But QMF comes with its own licensing fee. And as far as I understand, SPUFI is free. So some shops don't keep QMF.

mbr_raja · Posted: Mon Feb 26, 2007 1:26 pm

The SPUFI has fewer capability when compared to QMF. In general we can run QMF for Query execution, db2 commands, MF commands as well as Report Query. But in the case of SPUFI, there is no Report query to format the output results. As the User point of view, SPUFI is quite common thing available in every DB2 subsystem. But QMF is optional and it is also depends upon installation of DB2.

sachin_star3 · New User Joined: 30 Sep 2006 Posts: 78 Location: pune

these two have use different usage
use SPUFI when want execute the single or more sql queries but dont want formatted output then you go for SPUFI

AND for QMF use when you want the output in fomatted way
of want the modified output,so use qmf when we want execute single query or want formatted query

i use mostly use spufi
but when i use cobol-db2 programme at that time for testing of sql queries i go for QMF by just putting "START QMF" Iin TSO COMMAND LINE

FROM -
SACHIN BORASE
PUNE

mustafashaikh · New User Joined: 22 Nov 2006 Posts: 2 Location: pune

QMF -

1. More than one query can be execute at a time
2. It consists ";" at the end of query.

SPUFI -

1. Only one query execute at a time.
2. not necessary to end with with ";"

guptae · Posted: Wed Feb 28, 2007 5:06 pm

Hi Mustafashaik,

MoLong · New User Joined: 07 Feb 2007 Posts: 32 Location: Chennai

SPUFI too supports multiple queries at a time.
Give delimeter in the settings screen and type more commands separating one another using delimeter.

narendra_12d · New User Joined: 07 Sep 2006 Posts: 7 Location: bangalore

the main difference btn SPUFI and QMF are as follows..

NOTES ON QMF:

the mean itself is QUERY MANAGEMENT FACILITY.
only one query can be executed at a time.
no of rows cannot be limited.
reports can be generated by using the QMF.
used by end users.
no SQL codes will be displayes.
SQL queries are coded in QMF tool.
SQL queries are executed by F2.
table can be edited.
no isolation errors can be specefied.
SQL procedures can be executed.
QMF cannot be executed by using JCL.

NOTES ON SPUFI:

the name itself is SQL Processor Using File Input.
multiple queries can be executed at a time.
no of rows can be limited.
no reports can be generated.
can be used by application programmer.
SQL code is displayed for errors.
SQL queries are executed by F3 r the ;;; in command prompt.
table cannot be edited.
isolation errors can be specified.
no SQL procedures can be executed.
SPUFI can be executed by using JCL.

wanderer · Posted: Sat Mar 03, 2007 5:13 am

That is quite interesting Narendra!

I might add a little that QMF does run in batch sometimes.

And the DSNTEP2 that everybody refers to batch SPUFI is not exactly related to SPUFI(it is a different program), although it is used to run SQL in batch.

vini_srcna · Posted: Tue Mar 06, 2007 4:03 pm

yes, DSNTEP2 is a productivity aid sample programs supplied by IBM. It is used to executely the SQL dynamically thru Batch job.