Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Diffrence b/w Platinum, QMF and DB2 Query Application DB2I
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join in SQL Query vickey_dw DB2 1 Tue Jan 17, 2017 12:15 am
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts TWS EQQYCAIN - not sure how to get ap... mbenaud IBM Tools 0 Wed Dec 14, 2016 8:45 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us