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.

Author: Gulmaran Tushakar
Country: Myanmar
Language: English (Spanish)
Genre: Relationship
Published (Last): 19 March 2006
Pages: 393
PDF File Size: 5.32 Mb
ePub File Size: 11.24 Mb
ISBN: 133-8-34645-901-7
Downloads: 39967
Price: Free* [*Free Regsitration Required]
Uploader: Vudoramar

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?

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.

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.


Are you using anything from C to call AS programs currently? CPF Duplicate job names found. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Do you need to do this from a C program or would it make sense to run a program on the IBM system that sends the spool file out instead? 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.

There are many different ways to go about this. Channel 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Element 2: Read this pyiscal file and split the rows into columns. Lots of ways to tackle this one Stack Overflow works best with JavaScript enabled. Figure out the command you need to run on the by doing it manually in the green screen.

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.