Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm
No new posts How to query MAXGENS of an existing P... Chuchulo Hatyzak JCL & VSAM 4 Wed Nov 22, 2017 10:23 pm
No new posts Native SQL Query kishpra DB2 1 Wed Nov 22, 2017 8:38 pm
No new posts Query on IEFBR14 with GDG Ashishpanpaliya JCL & VSAM 4 Tue Nov 07, 2017 8:34 pm
No new posts Query on XMITIP abdulrafi All Other Mainframe Topics 1 Wed Oct 25, 2017 6:54 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us