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: Vugrel Aratilar
Country: Jordan
Language: English (Spanish)
Genre: Travel
Published (Last): 11 August 2015
Pages: 315
PDF File Size: 20.33 Mb
ePub File Size: 10.42 Mb
ISBN: 273-7-25926-700-1
Downloads: 49283
Price: Free* [*Free Regsitration Required]
Uploader: Fenrill

Specifies the date and time the spooled file was created. All my answers were extracted from the “Big Dummy’s Guide to the As” and I take no responsibility for any of them. Lastly if its just querying tables you can do that using perl on a Win32 system and ump the results directly conbert a spreadsheet and email it.

Channel 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Element 2: The assigned channel values as specified on the command are as follows:.

I’m trying to code a console application to get the spool file from as to a different destination as a text file.

Converting a spooled file to PDF

Other values up to 12 repetitions Element 1: By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Convrt of Service. Hi Jamie, Thanks for the quick response.

I found out the mistake. This parameter is considered after the job name, user name, az400 number, spooled file name, and spooled file number parameter requirements have been met. The range of valid line numbers is 1 through Job name JOB Specifies the job that created the spooled file whose data records are to be copied. The 4-byte print control code is created. Lots of ways to tackle this one There tl many different ways to go about this. The FCFC 1-byte print control character is used and takes advantage of the assigned channel values in formatting the output.


Once you fiile the options, you’ll be better equipped to figure out how to handle the problem in C. Creation date date Specify the date the spooled file was created. Email Required, but never shown.

ibm midrange – how to get as spool files to text in c# – Stack Overflow

User name Specify the user name that identifies the user profile under which the job is run. Figure out the command you need to run on the by doing it manually in the conveet screen. From that point, you can grab the file from that shared IFS directory in C. Specifies which print control characters if any are to replace the spooled file’s internal print control characters.

There are also lots of commercial packages that can do this stuff for you automagically. Your best best converg to do like Mike suggested and call a program already on the to convert the spool file to a shared IFS directory.

Regards, Manty Attached Files Dummy. 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.

  FMFM 6-5 PDF

IBM i: Export a spooled file to your PC

CPF Not authorized to ho file. The assigned line number for channel 1 is line 1. Then, put a file in a shared directory and test pulling that into your program.

Specifies the name of the system where the job that created the spooled file JOB parameter ran. 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? The assigned channel values as specified on the command are as follows: Are you using anything from Fipe to a4s00 AS programs currently? If no current library entry exists in the library list, QGPL is used.

Number Specify the system-assigned job number.

We have a requirement, where in the AS spool file report needs to be fjle to a formatted excel sheet and mailed to the respective people.

Element list Optional Element 1: 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. Qualified job name Optional Qualifier 1: The only valid values for this parameter are 1 through