A module for the IBM i (AS, iSeries) that enables you an easy conversion of print spool files from the IBM i to XML flies. – Spool to XML in seconds!. On iSeries, instead of transferring a spool file to an Excel spreadsheet, use the CPYTOIMPF command to create a CVS text file that can be easily loaded into. 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.

Author: Migor Zolojora
Country: Guatemala
Language: English (Spanish)
Genre: Software
Published (Last): 25 December 2014
Pages: 213
PDF File Size: 1.23 Mb
ePub File Size: 16.96 Mb
ISBN: 333-9-44153-800-4
Downloads: 78319
Price: Free* [*Free Regsitration Required]
Uploader: Tojazragore

Have you tried what is suggested here Just using this way to generate PDF.

February 11th, Scroll through the list of programs to find the following this is from a 7. The function requires that product TS1 option 01 be available to use. If this is you feel free to use the Contact Form to send me the comment and I will post it for you, please include the title of the post so I know which one to post the comment to.


The newly copied data is added to data existing in the member. Channel number refers to a method of determining skipping for reports.

You can learn more about these from the IBM web site: Just a question – How if at all do I get it to convert Hebrew characters? Thank you very much. I cannot put my hand on my heart and say for sure as the ad400 I have access to only have the US-English character set.

Convert IBM i (AS/) data and Spool files into XML

Specifies the name of the system where the as00 that created the spooled file JOB parameter ran. Anonymous November 13, at 9: Before you can do what I will describe in this post you need to check if you have the necessary licensed program, Transform Services, installed on your IBM i.

I can verify the copy doesn’t work at V6R1, but you can circumvent that. The licensed program code if different depending upon which release your server is running: Simon Hutchinson February 20, at 4: When you copy a spooled file to a physical file, certain information is lost or changed.

KJB March 27, at Tim Austin Psool 31, at 4: Simon Hutchinson March 26, at 9: Sreedhar iSeries follower March 26, at 7: User name Specify the user name that identifies the user profile under which the job fo run.


IBM i: Converting a spooled file to PDF

Steve Coyle April 22, at 1: 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. This is a required parameter. The trick is not in making the PDF out of the spool file, but in placing the resulting PDF in a network directory after the creation CPF Necessary resource not available.

Bob Schaefer March 28, at Learn about this website’s comments policy here. CPF Duplicate job names found. Number Specify the system-assigned job number.

Each assigned channel must have a corresponding line number to provide the correct positioning on a report. Job name Name Qualifier 2: