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: Zololmaran Tejinn
Country: Albania
Language: English (Spanish)
Genre: Literature
Published (Last): 10 October 2009
Pages: 75
PDF File Size: 2.54 Mb
ePub File Size: 6.25 Mb
ISBN: 465-8-40973-280-1
Downloads: 25602
Price: Free* [*Free Regsitration Required]
Uploader: Zulugami

The only valid values for this parameter are 1 through To data base file name Specify the file name of the physical file to receive the copy. Read this pyiscal file and split the rows into columns.

I have seen the examples posted. Then, put a file in a shared directory and test pulling that into your program. I think we probably use 4 or 5 of them at my work. I would recommend testing out both parts separately before you merge them into a single program.

Copy Spooled File (CPYSPLF)

Today’s Posts Member List Calendar. Number Specify the system-assigned job number.

Use this value when the spooled file create date and time parameter is to take precedence over the job system flle when selecting a spooled file. This parameter is considered after the job name, user name, job number, spooled file name, and spooled file number parameter requirements have been met.


Bar code data is lost. Post as a guest Name.

From that point, you can grab the file from that shared IFS directory in C. 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.

Exporting a spooled file to your PC

We have a requirement, where in the AS spool file report needs to be converted to a formatted excel sheet and mailed to the respective people. At the end, you can put those together. There are also lots of commercial packages that can do this stuff for you automagically. Here are the steps: This is a required parameter.

sponsored links

The range of valid line numbers is 1 through The AS spool report is generated. Dear all, Hope evry1 is doing great Qualified job name Optional Qualifier 1: Creation date Date Element 2: I’m trying to code a console application to get the spool file from as to a different destination as a text file. Also check out this article which discusses how to copy spool files to your PC via Operations Navigator: 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.


CPF Copy request failed. If no current library entry exists in the library list, QGPL is used. I wasn’t allowed to call the APIs. There are many different ways to go about this. Sourcecode to open a file.

Channel 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Element 2: Specifies a user-defined physical database file to which the spooled records will be copied. User name Specify the user name that identifies the user profile under which the job is run. Email Required, but never shown. To data base file Name Qualifier 2: An AFP fIle has an intricate format. Specifies the date and time the spooled file was created. Figure out the command you need to run on the by doing it manually in the green screen.

Where allowed to run: Sign up using Email and Password. Graphics data is lost. If this member does not exist, a member is created and the copy continues. Creation date date Specify the date the spooled file was created.