Q:
Automatic transfer of AS400 output file to PC folder
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.
I usually do this manually. Hope someone can show me the process/code to this. Thanks a lot.
ASKED:
Aug 3 2009 2:09 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
