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
 
Saving QMF dat to MS excel

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News
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    Post subject: Saving QMF dat to MS excel
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    Post subject:
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    Post subject: Reply to: how can i extract the data
Reply with quote

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

Site Director


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

PostPosted: Sun Feb 17, 2008 6:32 am    Post subject:
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    Post subject: Reply to: Saving QMF dat to MS excel
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    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts saving your settings in ISPF. VintageReceiver TSO/ISPF 9 Wed Jul 26, 2017 6:42 pm
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts How to read a excel sheet and load it... Radhika Nambiar Java & MQSeries 10 Wed Mar 30, 2016 4:49 pm
No new posts Daylight Saving this Weekend Bill O'Boyle All Other Mainframe Topics 1 Fri Mar 11, 2016 8:40 pm

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