As Asked: September 10, AM Last updated: October 25, 7: 31 PM. Related Questions. how to convert physical file to spool file? Navigation. 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. It can be painful to convert spool files from the IBM i, iSeries or AS to user friendly reports such as PDF and Excel without the right tools. Paperless Report.
|Published (Last):||5 February 2004|
|PDF File Size:||20.18 Mb|
|ePub File Size:||19.45 Mb|
|Price:||Free* [*Free Regsitration Required]|
In the example above, it’s redirected to a streamfile named mysplftxt. February 12th, MY one of spooled file like this: You can change your settings at any time.
The real issue is how do you expect fjle map a free flowing format such as your example to a row and column format like Excel? That’s all there is to it. I have attached a sample of how the excel sheet should come up March 30th, We have convet requirement, where in the AS spool file report needs to be converted to a formatted excel sheet and how to convert as400 spool file to to the respective people.
I have seen the examples posted. Submit your e-mail address below.
Ask a Question
Your password has been sent to: Please try again later. X Forms to PlanetPress 5.
Read this pyiscal file and split the rows into columns. Simplest for me is a command similar to this: The job qualifier, file name, and spooled file number are shown at the top of the Work with Spooled File Attributes screen.
Repeat Step 8 until all of the spooled files have been copied to the same physical file member. TXT to download the file to the PC.
April 13th, Since the intent is to copy a spooled file, modify the data in the spooled file, and then copy it back to a new spooled file, a source physical file should be created using the Create Source Physical File CRTSRCPF command. This is an example.
How to convert as400 spool file to it use for capture inputted spool data?
Convert spool file to physical file in AS/ – IT Answers
This will take you to the Work with Spooled File Attributes screen. Check here to start a new keyword search.
Please enter a reply. Sign up or log in Sign up using Google. Document information More ro for: Dear all, Hope evry1 is doing great Join Stack Overflow to learn, share knowledge, and build your career. Edit or remove the text that you want.
Without this, the OVRPRTF command may not take effect at all which would result in losing all line and page breaks in the new spooled file. Press the F21 select assistance level key, and ensure that the assistance level is set to 2 intermediate.
It is meant to handle Microsoft format, including Excel.