IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Diffrence b/w Platinum, QMF and DB2 Query Application DB2I


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
blpraveenspi
Currently Banned

New User


Joined: 03 Jan 2007
Posts: 3
Location: Mysore

PostPosted: Wed Jan 31, 2007 6:18 pm
Reply with quote

Hi,
Why a company need three different Query application?.What difference exits between these three query application?.
Back to top
View user's profile Send private message
prav_06
Warnings : 1

Active User


Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands

PostPosted: Thu Feb 01, 2007 12:19 pm
Reply with quote

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
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Tue Feb 06, 2007 4:26 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts 10 byte RBA conversion -non applicati... JCL & VSAM 1
No new posts RC query -Time column CA Products 3
No new posts DB2 Event passed to the Application P... DB2 1
No new posts Dynamically pass table name to a sele... DB2 2
No new posts Query on edit primary command CLIST & REXX 5
Search our Forums:

Back to Top