QMF vs SPUFI

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mvsguy - 25 Jul 2007 13:17 GMT

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

Reply to this Message

Lew - 25 Jul 2007 16:51 GMT

it is a lot easier to format nice reports with qmf.

Reply to this Message

mvsguy - 25 Jul 2007 20:12 GMT

> 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?

Reply to this Message

Mark A - 26 Jul 2007 00:47 GMT

>> 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.

Reply to this Message