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):||16 June 2005|
|PDF File Size:||16.21 Mb|
|ePub File Size:||3.54 Mb|
|Price:||Free* [*Free Regsitration Required]|
Sign up or log in Sign up using Google. We have a requirement, where in as00 AS spool file report needs to be converted to a formatted excel sheet and mailed to the respective people. It also seems like there are some classes to support FTP interaction in C.
Exporting a spooled file to your PC
I would recommend testing out both parts separately before you merge them into a single program. You guys have any idea or suggestion on how to start this?
I think we probably use 4 or 5 of them at my work. Job name name Specify the name of the job that created the spooled psool. That’s the plan but without opening the file the rest doesn’t work. Line The line number assigned for the channel number in the same list.
I have the same problem. Specifies a list of channel numbers with their assigned line numbers. Do you need to do this from a C program yo would it make sense to run a program on the IBM system that sends the spool file out instead?
ibm midrange – how to get as spool files to text in c# – Stack Overflow
Hi Jamie, Thanks for the quick response. I have seen the examples posted. The only valid values for this parameter are 1 through Have you tried any of them? The FCFC 1-byte print control character is used and takes advantage of the assigned channel values in formatting the output.
Despite the misleading error message, it was an authorization problem. Are you using anything from C to call AS programs currently?
Copy Spooled File (CPYSPLF)
Print lines that are all blank are not copied. This parameter is considered after conert job name, user name, job number, spooled file name, and spooled file number parameter requirements have been met. I’m trying to code a console application to get the spool file from as to a different destination as a text file.
CPF Copy request failed. April 13th, Job name Name Qualifier 2: The newly copied data is added to data existing in the member.
February 12th, Other values up to 12 repetitions Element 1: Lastly if its spoop querying tables you can do that using connvert on a Win32 system and ump the results directly into a spreadsheet and email it. 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.
Bar code data is lost. From that point, you can grab the file from that shared IFS directory in C. How to convert a AS spool file report to a formatted excel sheet?