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: Dousho Tubar
Country: Uzbekistan
Language: English (Spanish)
Genre: Spiritual
Published (Last): 20 October 2006
Pages: 43
PDF File Size: 4.93 Mb
ePub File Size: 17.24 Mb
ISBN: 985-8-92785-954-9
Downloads: 53262
Price: Free* [*Free Regsitration Required]
Uploader: Meztir

CPF Necessary resource not available. There are also lots of commercial packages that can do this stuff for you automagically. Once you know the options, you’ll be better equipped to figure out how to handle the problem in C.

Each assigned channel must have a corresponding line spopl to provide the correct positioning on a report. Figure out the command you need to run on the by doing it manually in the green screen. Specifies the date and time the spooled file was created.

If this file does not exist at the time of the copy, the copy will fail. Channel 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Element 2: Also check out this article which discusses how to copy spool files to your PC via Operations Navigator: You can save the file to a shared IFS directory mapped to a Windows drive and have your c program get it from there. The assigned line number for channel 1 is line 1. Here are the steps: I wasn’t allowed to call the APIs.


This value is not allowed for spooled files which exist on primary or secondary auxiliary storage pools.

IBM i: Converting a spooled file to PDF

The newly copied data is added to data existing in the member. Line The line number assigned for the channel number in the same list.

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. Line 3 assigned to channel 1 Line 15 assigned to channel 4. Regards, Manty Attached Files Dummy. I think we probably use 4 or 5 convett them at my work. Sign up using Email and Password. Bar code converg is lost. From that point, you can grab the file from that shared IFS directory in C.

February 11th, I have attached a sample of how the excel sheet should come up CPF Not authorized to spooled file.

Converting a spooled file to PDF

To data base file name Specify the file name of the physical file to receive the copy. Hi Jamie, Thanks for the quick response. Job name Name Qualifier 2: If this member does not exist, a member is created and the copy continues. By clicking “Post Your Answer”, you acknowledge that convdrt have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.


I get the error directly when calling the API, this is not an error message during the work of the call.

Creation date Date Element 2: Specifies a list of channel numbers with their assigned line numbers. Job name JOB Specifies the job that created the spooled file whose data records are to be copied.

Channel channel-number Specify which channels are used to control skipping on a report. CPF Copy request failed. 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?

I have the same problem. Job name name Specify the name of the job that created the spooled file.

Have you tried any of them? Maybe someone has a hint? Despite the misleading error message, it was an authorization problem. That’s the plan but without opening the file the rest doesn’t work.

Lots of ways to tackle this one