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
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Praveen Kumar Singh
Warnings : 1

New User


Joined: 02 Jan 2007
Posts: 6
Location: Mumbai

PostPosted: Fri Feb 23, 2007 2:46 am    Post subject: What is the differance b/w using SPUFI and QMF.
Reply with quote

Tell me which is better of the two and why?
Back to top
View user's profile Send private message

Praveen Kumar Singh
Warnings : 1

New User


Joined: 02 Jan 2007
Posts: 6
Location: Mumbai

PostPosted: Fri Feb 23, 2007 2:55 am    Post subject:
Reply with quote

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

Warning: Do not Repost
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Fri Feb 23, 2007 6:58 am    Post subject:
Reply with quote

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

New User


Joined: 15 Nov 2004
Posts: 26
Location: Chennai, India

PostPosted: Mon Feb 26, 2007 1:26 pm    Post subject: Diff between SPUFI and QMF
Reply with quote

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.
Back to top
View user's profile Send private message
sachin_star3
Warnings : 1

New User


Joined: 30 Sep 2006
Posts: 78
Location: pune

PostPosted: Tue Feb 27, 2007 12:27 pm    Post subject:
Reply with quote

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

New User


Joined: 22 Nov 2006
Posts: 2
Location: pune

PostPosted: Wed Feb 28, 2007 4:39 pm    Post subject:
Reply with quote

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

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Feb 28, 2007 5:06 pm    Post subject:
Reply with quote

Hi Mustafashaik,

Quote:
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 ";"



I dont think that u r correct . Can u provide the link which support ur post
Back to top
View user's profile Send private message
MoLong

New User


Joined: 07 Feb 2007
Posts: 32
Location: Chennai

PostPosted: Thu Mar 01, 2007 10:14 am    Post subject:
Reply with quote

SPUFI too supports multiple queries at a time.
Give delimeter in the settings screen and type more commands separating one another using delimeter.
Back to top
View user's profile Send private message
narendra_12d

New User


Joined: 07 Sep 2006
Posts: 7
Location: bangalore

PostPosted: Sat Mar 03, 2007 1:32 am    Post subject: What is the differance b/w using SPUFI and QMF.
Reply with quote

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

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Sat Mar 03, 2007 5:13 am    Post subject:
Reply with quote

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

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Tue Mar 06, 2007 4:03 pm    Post subject:
Reply with quote

yes, DSNTEP2 is a productivity aid sample programs supplied by IBM. It is used to executely the SQL dynamically thru Batch job.
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 SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
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


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