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. AS/ Spool Files Physical files don’t convert to spooled files. The RUNQRY command can print records from a physical file with very little. This allows the first character to be used as a control character so that you can convert the contents of the physical file back to a spool file and.

Author: Dougul Samur
Country: Cape Verde
Language: English (Spanish)
Genre: Career
Published (Last): 2 February 2016
Pages: 184
PDF File Size: 4.65 Mb
ePub File Size: 19.15 Mb
ISBN: 841-5-33360-895-7
Downloads: 95332
Price: Free* [*Free Regsitration Required]
Uploader: Kigami

This option may be useful for microfiche production.

How to convert AS/ spool file into text file ? – Objectif Lune Tech Support Self Help

Creation date date Specify the date the spooled file was created. Number Specify the system-assigned job number. You should conbert it, it may help you get rid of your current unstable tool I hope this helps. You may be able to convert to a plain text format simply with a Create File and making use of data selections and maybe splitters if it’s in a format that’s easy to use like XML, CSV, etc Thank you very much! If this member does not exist, a member is created and the copy continues.


Job name JOB Specifies the job that created the spooled file whose data records are to be copied.

CPF Duplicate job names found. Line The line number assigned for the channel number in the same list. Specifies a list of channel numbers with their assigned line numbers.

Converting a spooled file to PDF

Below are the options you have as far as converting to text goes: Channel 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Element 2: Fille number refers to a method of determining skipping for reports. If this file does not exist at the time of the copy, the copy will fail. Hi Andy, It all depends on what format your data comes in.

Print lines that are all blank are not copied. Creation date Date Element 2: Use this value when the job system name parameter or the spooled flle create date and time parameter is to take precedence over the spooled file number when selecting a spooled file.

This parameter is considered after the job name, user name, job number, slool file name, and spooled file number parameter requirements have been met.

X Forms to PlanetPress 5. Where allowed to run: Graphics data is lost. This conversion allows the use of spooled files in applications using microfiche, data communications, or data processing.


Previous Topic Index Next Topic. To data base file Name Qualifier 2: When I need to design the form by planetperss design, I must convert the report into hoow files, and then I can load the text file by data selector sample data file in planetpress design, so I can base on the format of report to do. Qualified job name Optional Qualifier 1: The assigned channel values as specified on the command are as follows:.

Can it converts captured data fo text format?

CPF Member not added. CPF Necessary resource not available. Switch to Threaded Mode. Objectif Lune, Montreal, Qc. Dear everyone, I’ve one question as below. You are not logged in.

When you copy a spooled file to a physical file, certain information is lost or changed. It mimics some of the functionality found in PlanetPress Workflow. The confert channel values as specified on the command are as follows: Job name name Specify the name of the job that created the spooled file.