Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search 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 Tech Help & IT News
Author Message
chandracdac
Warnings : 1

New User


Joined: 15 Jun 2007
Posts: 39
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
References
rpuhlman

Active User


Joined: 11 Jun 2007
Posts: 76
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
Moved: Fri Feb 15, 2008 5:26 pm by superk From DB2 to PC Tech Help & IT News
chandracdac
Warnings : 1

New User


Joined: 15 Jun 2007
Posts: 39
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

Global Moderator


Joined: 23 Nov 2006
Posts: 9184
Location: 221 B Baker St

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
Warnings : 1

New User


Joined: 15 Jun 2007
Posts: 39
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
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Tech Help & IT News All times are GMT + 6 Hours
Page 1 of 1