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
 

 

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 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
No new posts Formatting data from Excel to mainframe kishpra JCL & VSAM 5 Fri Feb 19, 2016 7:12 pm
No new posts Empty excel attachment in mail receiv... gs185008 COBOL Programming 8 Mon Jul 13, 2015 7:45 pm
This topic is locked: you cannot edit posts or make replies. FTP excel file to mainframe dataset Robert Sample All Other Mainframe Topics 12 Sun Apr 12, 2015 2:25 am


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