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 March 2006|
|PDF File Size:||5.32 Mb|
|ePub File Size:||11.24 Mb|
|Price:||Free* [*Free Regsitration Required]|
Post as a guest Name. The newly copied data is added to data existing in the member. The FCFC 1-byte print control character is used and takes advantage of the assigned channel values in formatting the output.
Exporting a spooled file to your PC
I have attached a sample of how the excel sheet should come up I have been looking around but I haven’t found a small code to start from there, I been searching around and haven’t found anything close. To convwrt base file name Specify the file name of the physical file to receive the copy.
Email Required, but never shown. CPF Necessary resource not available.
Number Specify the system-assigned job number. If no current library entry exists in the library list, QGPL is used.
Copy Spooled File (CPYSPLF)
Once you know the options, you’ll be better equipped to figure out how to handle the problem in C. You guys have any idea or suggestion on how to start this? The 4-byte print control code is created.
Job name Name Qualifier 2: Today’s Posts Member List Calendar. It also seems like there are some classes to support FTP interaction in C. This parameter is considered after the job name, user name, job number, spooled file name, and spooled file number parameter requirements have been met. 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.
If this member does not exist, a member is created and the copy continues. Lastly if its just querying tables you can do that using perl on a Win32 system and ump the results directly into a spreadsheet and email it.
Line The line number assigned for the channel number in the same list. There are examples to do all of this on this site CPF Copy request failed.
Regards, Manty Attached Files Dummy. Parameters Examples Error messages. How to convert a AS spool file report to a formatted excel sheet?
Channel channel-number Specify which channels are used to control skipping on a report. Each assigned channel must have a corresponding line number to provide the correct positioning on a report.
This is a required parameter. Converr found out the mistake.
Maybe someone has a hint? CPF Not authorized to spooled file. February 27th, I think we probably use 4 or 5 of them at my work. 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.