Software/Hardware used: As Asked: September 10, AM Last updated: October 25, PM. Related Questions. Spool · FILES. There has always been a need to convert spool file into PC supported file for transmission of spool file or maintaining record of the iSeries report in a PC or. 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.
|Published (Last):||19 September 2010|
|PDF File Size:||15.59 Mb|
|ePub File Size:||13.37 Mb|
|Price:||Free* [*Free Regsitration Required]|
Your best best is to do like Mike suggested and call a program already on the to convert the spool file to a shared IFS directory. Job name Name Qualifier 2: March 30th, I have attached a sample of how the excel sheet should come up Each assigned channel must have a corresponding line number converg provide the correct positioning on a report.
Channel channel-number Specify which channels are used to control skipping on a report. I wasn’t allowed to call the APIs. When you copy a spooled file to a physical file, certain information is lost or changed. Today’s Posts Member List Calendar. Print lines that are all blank are cpnvert copied.
IBM i: Export a spooled file to your PC
The AS spool report is generated. I think we probably use 4 or 5 of them at my work. Where allowed to run: Once you know the options, you’ll be better equipped to figure out how to handle the problem in C. CPF Cannot convert spooled file data. All my answers were extracted xs400 the “Big Dummy’s Wpool to the As” and I take no responsibility for any of them.
Use this value when the job system name parameter or the spooled file create date and time parameter is to take precedence over the spooled file number when selecting a spooled file. This option may be useful for microfiche production.
Specifies which print control characters if any are to replace the spooled file’s internal print control characters.
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.
CPF Member not added. This conversion allows the use of spooled files in applications using microfiche, data communications, or data processing.
Despite the misleading error message, it was an authorization problem. Specifies the name of the system where the job that created the spooled file JOB parameter ran. Lots of ways to tackle this one To data base file Name Qualifier 2: CPF Duplicate job names found.
Converting a spooled file to PDF
How to convert a AS spool file report to a formatted excel sheet? Parameters Examples Error messages.
This parameter is considered after the job name, user name, job number, spooled file name, and spooled file number parameter requirements have been met. Lastly if its just querying tables you can do that splol perl on a Win32 system and ump the results directly into a spreadsheet and email it. Channel number refers to a method of determining skipping for reports.
Maybe someone has a hint? Number Specify the system-assigned job number.
Sign up using Email and Password. Cpnvert assigned channel values as specified on the command are as follows: This value is not allowed for spooled files which exist on primary or secondary auxiliary storage pools.
CPF Not authorized splol spooled file.