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

Saving QMF dat to MS excel


IBM Mainframe Forums -> PC Guides & IT News
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 92
Location: bangalore

PostPosted: Fri Feb 15, 2008 1:41 pm
Reply with quote

hi ,

i am running a query in qmf, and i want to save the result of that query in the word or excel,is there any command for doing this,

if any body is having the information please provide me


Thanks in advance
Back to top
View user's profile Send private message
rpuhlman

New User


Joined: 11 Jun 2007
Posts: 80
Location: Columbus, Ohio

PostPosted: Fri Feb 15, 2008 5:24 pm
Reply with quote

Are you using QMF for Windows?
Back to top
View user's profile Send private message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 92
Location: bangalore

PostPosted: Sat Feb 16, 2008 6:02 pm
Reply with quote

no i am using qmf in mainframes.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sun Feb 17, 2008 6:32 am
Reply with quote

Hello,

Save the qmf result as a file on the mainframe (EXPORT) and then download that result dataset to the target system.

Make sure all of the data in your file to be downloaded is standard text - not packed or binary.
Back to top
View user's profile Send private message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 92
Location: bangalore

PostPosted: Tue Feb 19, 2008 10:51 am
Reply with quote

Thanks to all i got it
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 -> PC Guides & IT News

 


Similar Topics
Topic Forum Replies
No new posts Converting fixed length file to excel... IBM Tools 7
No new posts mail attachment with excel format All Other Mainframe Topics 2
This topic is locked: you cannot edit posts or make replies. Excel VBA integration with AS400 Macr... All Other Mainframe Topics 1
No new posts Do we need to restart DB2 Z/OS for DA... DB2 0
No new posts Can we create REXX ouput in an Excel ... CLIST & REXX 3
Search our Forums:

Back to Top