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: Togami Kaziktilar
Country: Grenada
Language: English (Spanish)
Genre: Music
Published (Last): 5 December 2014
Pages: 207
PDF File Size: 4.70 Mb
ePub File Size: 18.89 Mb
ISBN: 316-9-47965-735-6
Downloads: 20987
Price: Free* [*Free Regsitration Required]
Uploader: Vohn

Update I have received several communications informing me that you can use the Operation Navigator to convert a spool file to a PDF file.

Converting a spooled file to PDF

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. Where allowed to run: I have seen the examples posted. Channel 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Element 2: Each assigned channel must have a corresponding line number to provide the correct positioning on a report.

February 12th, Just using this way to generate PDF. Paul thank you bring this to my attention. If this file does not exist at the time of the copy, the copy will fail.


IBM i: Converting a spooled file to PDF

From IBM’s Suport documents: Use this value when the spooled file create date and time parameter is to take precedence over the job system name when selecting a spooled file. If it is not installed on your server ask your IBM i administrator to install: The FCFC 1-byte print control character is used and takes advantage of the assigned channel values in formatting the output.

Very helpful article Simon! This parameter is considered after the job name, user name, job number, spooled file name, spooled file number, and job system name parameter requirements have been met. February 27th, Using that file this worked.

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. User Name Qualifier 3: To data base file Name Qualifier 2: Job name name Specify the name of the job that created the spooled file. This conversion allows the use of spooled files in applications using microfiche, data communications, or data processing.

There are also lots of commercial packages that can do this stuff for you automagically.

You can learn more about these from the IBM web site: Just create a printer if you have client access and its print queue. Juan Dragone March 26, at 8: Anonymous July 3, at 8: The 4-byte print control code is created. Simon Hutchinson Spoool 8, at 4: When you copy a spooled file to a physical file, certain information is lost or changed. This is a required parameter. I am not so sure that would work in most scenarios I use this for as they are batch jobs that run as part of the night run.


Specifies a user-defined physical database file to which the spooled records will be copied.

Job name Name Qualifier 2: Anonymous October 7, at 2: The assigned channel values as specified on the command are as follows:. Dear all, Hope evry1 is doing great If I could attach some screen prints’ I’d show you.

The assigned line number for channel 1 is line 1. This value is not allowed for spooled files which exist on primary or secondary auxiliary storage pools. Bob Schaefer March 28, at Ben Leon March 26, at 9: I have a physical file with a record length on my box that I’ve been using to copy spool files in for different reasons.

Graphics data az400 lost. February 11th, To prevent “comment xonvert all comments are moderated. Number Specify the system-assigned job number.