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: Moogushura Vudole
Country: Dominican Republic
Language: English (Spanish)
Genre: Education
Published (Last): 16 June 2005
Pages: 478
PDF File Size: 16.21 Mb
ePub File Size: 3.54 Mb
ISBN: 696-1-92232-826-4
Downloads: 1830
Price: Free* [*Free Regsitration Required]
Uploader: Diran

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?

The assigned line number for channel 1 is line 1. Read this pyiscal file and split the rows into columns. Stack Overflow works best with JavaScript enabled. Element list Optional Element 1: Channel 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Element 2: 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.


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

I have attached a sample confert how the excel sheet should come up Number Specify the system-assigned job number. I have been looking around but I haven’t found a small code to start from there, I been ad400 around and haven’t convfrt anything close. Job name JOB Specifies the job that created the spooled file whose data records are to be copied. Login or Sign Up. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

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?

Back to top