Automatic transfer of AS400 output file to PC folder

30 pts.
Tags:
AS/400 output files
AS/400 Transfer
DB2
Is there a way to automatically transfer an output file to PC folder in an Excel form? My boss want me to create a CL program that every time the output file was created, it automatically convert that output file to Excel(numeric values in comma seperated) in a PC folder. I usually do this manually. Hope someone can show me the process/code to this. Thanks a lot.
ASKED: August 3, 2009  2:09 AM
UPDATED: August 3, 2009  4:10 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

To my knowledge there is no way to automatically convert a spool file to excel using CL. You would need to convert the program that creates the spool file so that it creates the excel sheet instead of the spool file. I do this quite frequently and the users love it.

See this thread for instructions: http://itknowledgeexchange.techtarget.com/itanswers/how-to-export-data-from-as400-in-excel/

If this seems to be above your skill level, Google for a command called CVTPFXLS. You can then change the spool file program to write to a work file and then use the CVTPFXLS command to create a down and dirty excel sheet for the user. If you decide to go with this method, I would suggest that you get up to speed as soon as you can with the first method I mentioned as it is so much more flexible than CVTPFXLS.

After you create the sheet, you will need to find some way of delivering it to the user. You can do this either by mapping to a folder on the IFS or by having the program email the sheet to the requesting user.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following