This allows the first character to be used as a control character so that you can convert the contents of the physical file back to a spool file and. Any questions relating more to a PC type environment. This could be PC, Servers (both LINUX and WINDOWS). Historically, converting spooled files on IBM i has been a bit of an arduous task, but in recent releases, it’s become much easier. In April , I.
|Published (Last):||8 April 2012|
|PDF File Size:||6.64 Mb|
|ePub File Size:||17.63 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 a 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 Dummy.
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 iseriss.
I have seen the examples posted. February 12th, Here are the steps: Read this pyiscal file and split the rows into columns.
Creating PDF files from spool files | – From AS to IBM i
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. too
April 13th, Also check out this article which discusses how to copy spool files to your PC via Operations Navigator: February 27th, ,