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: Samulmaran Meztigar
Country: Ethiopia
Language: English (Spanish)
Genre: Career
Published (Last): 22 March 2016
Pages: 325
PDF File Size: 2.87 Mb
ePub File Size: 18.80 Mb
ISBN: 598-6-28651-920-8
Downloads: 70922
Price: Free* [*Free Regsitration Required]
Uploader: Dailmaran

Then, put a file in a shared directory and test pulling that into your program. Check with your system admin to find out which options are available for fetching job output. Bar code data is lost. The assigned channel values as specified on the command are as follows:. February 11th, Dear all, Hope evry1 is doing great Login or Sign Up. I get the error directly when calling the API, this is not an error message during the work of the call.


Exporting a spooled file to your PC

To data base file name Specify the file name of the physical file to receive the copy. Specifies the date and time the spooled file was created. Line 3 assigned to channel 1 Line 15 assigned to channel 4.

Email Required, but never shown. Lots of ways to tackle this one This option may be useful for microfiche production.

sponsored links

Specifies a user-defined physical database file to which the spooled records will be copied. There are many different ways to go about this. Lastly if its just querying tables you can do that using perl on a As4400 system and ump the results directly into a spreadsheet and email it.

I would recommend testing out both parts separately before you merge them into a single program.

Changing the parameters don’t change the error message. Specifies a list of channel numbers with their assigned line numbers.

Stack Overflow works best with JavaScript enabled. The only valid values for this parameter are 1 through I wasn’t allowed to call the APIs.


Parameters Spkol Error messages. Regards, Manty Attached Files Dummy. I have been building all of my reports with 3 options 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. CPF Copy request failed. Sign up using Facebook. CPF Necessary resource not available.

IBM i: Converting a spooled file to PDF

Are you using anything from C to call AS programs currently? Have you tried any of them? If no current library entry exists in the library list, QGPL is used.

Where allowed to run: All my answers were extracted from the “Big Dummy’s Guide to the As” and I take conveet responsibility for any of them.