What is difference between SPUFI and QMF?
-
- New Member
- Posts: 3
- Joined: Tue Jan 13, 2015 2:35 pm
What is difference between SPUFI and QMF?
Hi,
What is difference between SPUFI and QMF?
My answer: They are two different products but do the same thing.
If they are doing same thing, why would we have both of them?
I could not answer that...does anyone know about it?
What is difference between SPUFI and QMF?
My answer: They are two different products but do the same thing.
If they are doing same thing, why would we have both of them?
I could not answer that...does anyone know about it?
- Akatsukami
- Global Moderator
- Posts: 122
- Joined: Tue Oct 20, 2015 3:20 am
- Location: Bloomington, IL
- Contact:
Re: What is difference between SPUFI and QMF?
SPUFI executes dynamic SQL. QMF does also, but allows the output to be formatted, and for the SQL to be embedded in a simple procedural language
"I come to the conclusion that, men loving according to their own will and fearing according to that of the prince, a wise prince should establish himself on that which is in his own control and not in that of others." -- Niccolò Machiavelli
- Anuj Dhawan
- Founder
- Posts: 2802
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: What is difference between SPUFI and QMF?
You would like to use QMF when you are doing some professional work and want to generate good looking reports out of DB2. The reports can have optional Headers and Footers to make sense of that data in report for the end users or to say business users.
SPUFI, is a DB2 programmer's tool. It is usually used in between while writing a program to see the functionality and the validity of SQL query. And that's the reason, I believe, using SPUFI we can execute mutliple queries at one time.
You should also note the QMF is an add on product while SPUFI is freeely available at every shop which has IBM DB2.
Just a side note - DSNTEP2 is usually called as 'Batch SPUFI'. DNSTEP2 program is written in the PL/I programming language. Because DSNTEP2 is an application program, and the PL/I source code is provided with DB2, a knowledgeable PL/I programmer can easily modify the code however something of that sort is not true with QMF.
SPUFI, is a DB2 programmer's tool. It is usually used in between while writing a program to see the functionality and the validity of SQL query. And that's the reason, I believe, using SPUFI we can execute mutliple queries at one time.
You should also note the QMF is an add on product while SPUFI is freeely available at every shop which has IBM DB2.
Just a side note - DSNTEP2 is usually called as 'Batch SPUFI'. DNSTEP2 program is written in the PL/I programming language. Because DSNTEP2 is an application program, and the PL/I source code is provided with DB2, a knowledgeable PL/I programmer can easily modify the code however something of that sort is not true with QMF.
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
-
- New Member
- Posts: 3
- Joined: Tue Jan 13, 2015 2:35 pm
Re: What is difference between SPUFI and QMF?
Thanks Akatsukami and Anuj.
Anuj do we have a program equivalent for QMF also?
Anuj do we have a program equivalent for QMF also?
Re: What is difference between SPUFI and QMF?
Did you look in the manual? I believe, although this was over 25 years ago, that we ran all our QMF as batch.
Regards
Nic
Nic
Re: What is difference between SPUFI and QMF?
An similar thread on the same topic: viewtopic.php?f=8&t=179
- Anuj Dhawan
- Founder
- Posts: 2802
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: What is difference between SPUFI and QMF?
Please see the details at Running QMF in batch mode to run the QMF in Batch. I'm not sure if there is an equivalent program like DNSTEP2 to be called as "QMF in Batch"!
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
-
- New Member
- Posts: 3
- Joined: Tue Jan 13, 2015 2:35 pm
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute