473,320 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

QMF vs SPUFI

I'm a sysprog who is new to DB2. I've installed both QMF & SPUFI.

SPUFI seems far more flexible than QMF. Could someone explain the
difference? What does QMF do that SPUFI can't?

Regards,
MVSGuy

Jul 25 '07 #1
3 4062
Lew
it is a lot easier to format nice reports with qmf.
Jul 25 '07 #2
it is a lot easier to format nice reports with qmf.

Does that mean that QMF is mainly oriented at end users where SPUFI is
better for admins?

Jul 25 '07 #3
"mvsguy" <kk*****@fuse.netwrote in message
news:11**********************@19g2000hsx.googlegro ups.com...
>it is a lot easier to format nice reports with qmf.

Does that mean that QMF is mainly oriented at end users where SPUFI is
better for admins?
Yes, but you can also save the formatting in QMF and run it in a proc, which
is sometimes useful for admins also if they just need reports.

But for running scripts (like DDL, etc) spufi is needed because it can
execute a PDS member. SPUFI stands for SQL Processor Using File Input (or
something close to that depending on who you ask).

BTW, Spufi comes free with DB2 and QMF is priced extra.
Jul 25 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Mortimer | last post by:
Hi, I hope someone can help. I can't seem to find the answer to this anywhere. I need to change the SQL terminator from a semicolon (;) to an exclamation point within SPUFI in order to process a...
4
by: Jagdip Singh | last post by:
Hi, What is SPUFI regards, jagdip
1
by: Narender Singh | last post by:
Hi All, Is there anyway i can run the Online Spufi panel in batch. I don't want to use the DSNTEP2 program, b'cause it has a limit of 133 Record length. And apart from these i don't have access...
2
by: alex.mcshane | last post by:
Hi - I would be grateful for advice regarding the following. Via SPUFI, I am using an SQL member to generate further SQL Statements. Unfortunately, the generating output SQL statements are...
2
by: waimanlau | last post by:
Hi all! System Specs: DB2 UDB 7 on z/OS 390 The Problem: I want to execute a DDL file in my allocated Data Set. But the only thing that happens, when I press Enter is, that SPUFI jumps...
1
by: Aanand | last post by:
Hi all, A crazy thought just popped up into my head. Supposing your site didnt have SPUFI / QMF / Candle / Platinum or any tool that would let u create and run your SQLs, which would be the best...
0
by: mohandaspradeep | last post by:
Hi Is there any restriction in coding number of queries in a single file for a Batch SPUFI in DB2? Can a Batch SPUFI have any no of queries in it ?
1
by: LA1 | last post by:
I have telecomuter that logs into a mainframe to use a DB2 database. The client uses SPUFI to edit the database and make changes. The client has received from us a new notebook. Both his old and...
1
by: karpalmera | last post by:
Hello! I am using UDB 8 in Z/OS and I am trying to execute this statement in SPUFI select dept, name, row_number() over() from staff It just doesn't work. Here is the error message:...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.