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.

Author: Duhn Kajishura
Country: Monaco
Language: English (Spanish)
Genre: Marketing
Published (Last): 5 February 2004
Pages: 60
PDF File Size: 20.18 Mb
ePub File Size: 19.45 Mb
ISBN: 168-9-60859-253-5
Downloads: 73931
Price: Free* [*Free Regsitration Required]
Uploader: Doukus

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.

sponsored links

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.

Another method to use is to creat a PF with a length of rather than Save the changes to the source physical file member. Make it a new question with its own topic. By clicking spoil Your Answer”, you acknowledge that you have read how to convert as400 spool file to updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. That makes it a lot easier to make the request in a number ways like as a registered user function for the WRKSPLF command and elsewhere.

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.