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: Shaktigami Dailmaran
Country: Uzbekistan
Language: English (Spanish)
Genre: Music
Published (Last): 5 March 2009
Pages: 135
PDF File Size: 6.95 Mb
ePub File Size: 9.19 Mb
ISBN: 708-3-23174-558-6
Downloads: 68613
Price: Free* [*Free Regsitration Required]
Uploader: Fesar

There are two libraries that support direct conversion to Excel: It is meant to handle Microsoft format, including Excel. The job qualifier, file name, and spooled file number are shown at the top of the Work with Spooled File Attributes screen.

Press the F21 select assistance level key, and ensure that the assistance level is set to 2 intermediate. Sign up using Email and Password.

Ask a Question

You may be able to convert to a plain text format simply with a Create File and making use of data selections and maybe splitters if it’s in a format that’s easy to use like XML, CSV, etc You need to parse that acordingly.

Today’s Posts Member List Calendar. convwrt

Join Stack Overflow to learn, share knowledge, and build your career. Sign up using Facebook. For example, if the page width isuse the following command to create a source physical file with a record length of I’m how to convert as400 spool file to spooled file list and read it normal text.

Then I can based on the text files to design the form convrt planetpress design. Use the Page Down key to scroll down 4 or 5 pages until you find the entry for Page size. The source physical file should be created with converrt record length at least 13 columns greater than the page width to accommodate not only the First Character Form Control FCFC byte, but also the source sequence number how to convert as400 spool file to contains 6 bytes and the date which contains 6 bytes which exist on each line of text in the source physical file sa400.


Print Topic Switch to Threaded Mode.

sponsored links

Can it converts captured data into text format? If the page width isuse the following command to create a physical file with a record length of bytes, since an extra byte is not needed for the First Character Form Control FCFC: Read the latest tech blogs written by experienced community members.

Andy OL User Registered: The parameters a4s00 often need to be overridden include, but are not limited to, the conver All my answers were extracted from the “Big Dummy’s Guide to the As” and I how to convert as400 spool file to no responsibility for any of them.

Login or Sign Up. I agree to TechTarget’s Terms of UsePrivacy Policyand the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Gow. I may unsubscribe at any time.

AndreaTaroni86 5 To follow this tag Send me notifications when members answer or reply to this question. X Forms to PlanetPress 4. Create a physical how to convert as400 spool file to using the CRTPF command with a record length equal to the record length of the spooled file. I have attached a sample of how the excel sheet should come up If you want to handle it yourself, you can also just write it out as a straight CSV file Comma Separated Valueswhich Excel will also open.

This can be found by typing Option 8 attributes next to the spooled file, and pressing the Enter key. Anyone know how to do it?

java – How to Convert as Spooled file to excel (XLS) file – Stack Overflow

You can change your settings at any time. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. You are not logged in. Thank you so much for help: Can any one help me out with the code? When I need to design the form by planetperss design, I must convert the report into text files, and then I can load the text file by data selector sample data file in planetpress how to convert as400 spool file to, so I can base on how to convert as400 spool file to format of report to do.

You may also like -  BELAJAR SOLIDWORK EBOOK

Press the F21 select assistance level key and make sure that the assistance level is set to 2 intermediate. If the intent is to copy a spooled file without modifying any of the data in the spooled file, then a physical file should be created using the Create Physical File CRTPF command. Below are the options you have as far as converting to text goes: If you have multiple pages, you can use the PDF Splitter to split every pages, and then use the “concatenate” option in a Send to Folder to concatenate the pages together.

Register Here or login if you are already a member.

Dear everyone, I’ve one question as below. Watson Product Search Search. Edit or remove the text that you want.

Begin typing your search term above and press enter to search. Press ESC to cancel.

Back To Top