Any questions relating more to a PC type environment. This could be PC, Servers (both LINUX and WINDOWS). Prepare the SAVF a. On a PC, open IBM System i Access for Windows. b. Start a session with the AS/ server where spool file to be exported is located. c. Assuming you’re correct and that the program creates a spool file Sounds like it’s being sent to a printer automatically. By default, once a.
|Published (Last):||22 April 2013|
|PDF File Size:||1.65 Mb|
|ePub File Size:||19.43 Mb|
|Price:||Free* [*Free Regsitration Required]|
Login or Sign Up. Today’s Posts Member List Calendar.
How to convert a AS spool file report to a formatted excel sheet? February 11th, Dear all, Hope evry1 is doing great We have ho requirement, where in the AS spool file report needs to be converted to a formatted excel sheet and mailed to the respective people.
The AS spool report is generated. I have attached a sample of how the excel sheet should come up Regards, Manty Attached Files T.
There are examples to do all of this on this site Have you tried any of them? All my answers were extracted from the “Big Dummy’s Guide to the As” and I take no responsibility for any of them. Hi Jamie, Thanks for the quick response.
IBM FTP a Spooled File to PC – United States
I have seen the examples posted. February 12th, Here are the steps: Read this pyiscal file and split the rows into columns.
sp,f I have been building all of my reports with 3 options March 30th, Lots of ways to tackle this one There are also lots of commercial packages that can do this stuff for you automagically.
Lastly if its just querying tables you can do that using perl on a Win32 system and ump the results directly into a spreadsheet and email it.
April 13th, Also check out this article which discusses how to copy spool files to your PC via Operations Navigator: February 27th, ,