View previous topic :: View next topic
|
Author |
Message |
blpraveenspi Currently Banned New User
Joined: 03 Jan 2007 Posts: 3 Location: Mysore
|
|
|
|
Hi,
Why a company need three different Query application?.What difference exits between these three query application?. |
|
Back to top |
|
|
prav_06 Warnings : 1 Active User
Joined: 13 Dec 2005 Posts: 154 Location: The Netherlands
|
|
|
|
blpraveenspi,
Most of the mainframe installations have SPUFI wich would come along with db2 installation, QMF its more helpful to generate reports than SPUFI but its not a necessary for each an every Mainframe to have QMF, coming to platinum its a popular unload utility , used to unload and load tables, In general if there is requirement to use all these three utilities or more the company will have these installed in the Mainframe server.
Cheer's,
Thamilzan. |
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Hi blpraveenspi,
SPUFI :
1. SPUFI is just a quick and dirty SQL execution engine.
2. We can execute more queries at a time.
3. We know the sqlcode after executing the query. The result of the query will store in PS or in member of a PDS.
QMF:
1. QMF is a query/reporting environment with the ability to format reports.
2. We cannot execute more than one query.
3. We can't know the sqlcode of the query. The result of the query will not be stored anywhere. |
|
Back to top |
|
|
|