Gadong Taohy


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: Dilkree Dok
Country: Panama
Language: English (Spanish)
Genre: Science
Published (Last): 3 January 2012
Pages: 292
PDF File Size: 10.85 Mb
ePub File Size: 12.48 Mb
ISBN: 409-2-57167-495-6
Downloads: 84304
Price: Free* [*Free Regsitration Required]
Uploader: Fejar

I found out the mistake. That’s the plan but without opening the file the rest doesn’t work.

April 13th, Spoo, the date and time the spooled file was created. Changing the parameters don’t change the error message. Do sspool 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?

Figure out the command you need to run on the by doing it manually in the green screen. The newly copied data replaces all old data in the member because all old records have been cleared.

Exporting a spooled file to your PC

Here are the steps: Check with your system admin to find out which options are available for conert job output. Creation date Date Element 2: 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.

Lots of ways to tackle this one The assigned line number for channel 1 is line 1. When you copy a spooled file to a physical file, certain information is lost or changed.


Channel channel-number Specify which channels are used to control skipping on a report. Where allowed to run: CPF Member not added. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website ad400 subject to these policies.

sponsored links

Use this value when the job system name spiol or the spooled file create date and time parameter is to take precedence over the spooled file number when selecting a spooled file. The FCFC 1-byte print control character is used and takes advantage of the assigned channel values in formatting the output.

Each assigned channel must have a corresponding line number to provide the correct positioning on a report. To data base file Name Qualifier 2: There are also lots of commercial packages that can do this stuff for you automagically.

Sourcecode to open a file. Sign up using Facebook.

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

There are examples to do all of this on this site This conversion allows the use of spooled files in applications using microfiche, data communications, or data processing. Also check out this article which discusses how to copy spool files to your PC via Operations Navigator: Job name Name Qualifier 2: Other values up to 12 repetitions Element 1: I’m not sure about AS, but on system z there is typically an FTP service that can be used to retrieve job spool files. CPF Necessary resource not available.

I’m trying to code a console application to get the spool file from as to a different destination as a text file. The assigned channel values as specified on the command are as follows: Regards, Manty Attached Files Dummy.


User Name Qualifier 3: I think we probably use 4 or 5 of them at my work. The assigned channel values as specified on the command are as follows:. Job name name Specify the name of the job that created the spooled file. Number Specify the system-assigned job number. I have attached a sample of how the excel sheet should come up By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

Creation date date Specify the date the spooled file was created. Specifies which print control characters if any are to replace the spooled file’s internal print control characters. Line The line number assigned for the channel number in the same list. The range of valid line numbers is 1 through Channel number refers to a method of determining skipping for reports. What information are you trying to get from the spooled file?

Channel 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Element 2: If no current library entry exists in the library list, QGPL is used. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

This is a required parameter. To data base file name Specify the file name of the physical file to receive the copy.

I have seen the examples posted. Qualified job name Optional Qualifier 1: I would recommend testing out both parts separately before you merge them into a single program.