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: Guk Megis
Country: Sudan
Language: English (Spanish)
Genre: Love
Published (Last): 28 January 2008
Pages: 93
PDF File Size: 3.79 Mb
ePub File Size: 2.91 Mb
ISBN: 282-8-77791-275-5
Downloads: 43974
Price: Free* [*Free Regsitration Required]
Uploader: Kagazil

It mimics some of the functionality found in PlanetPress Workflow. 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.

This is a required parameter. Andy OL Guru Registered: When you copy a spooled file to a physical file, certain information is lost or changed. CPF Duplicate job names found. Line 3 assigned to channel 1 Line 15 assigned to channel 4.

X Forms to PlanetPress 4. Graphics data is lost. Creation date date Specify the date the spooled file was created. To data base file name Specify the file name of the physical file to receive the copy. gow

Below are as4000 options you have as far as converting to text goes: The range of valid line numbers is 1 through The assigned channel values as specified on the command are as follows: Hi Andy, It all depends on what format your data comes in.


Job name Name Qualifier 2: X Forms to PlanetPress 5. Channel 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Element 2: Job name name Specify the filee of the job ae400 created the spooled file. This conversion allows the use of spooled files in applications using microfiche, data communications, or data processing.

Creation date Date Element 2: If it is possible, can you give me some instructions on it? Andy, In answer to your questions: The assigned line number for channel 1 is line 1.

Converting a spooled file to PDF

Previous Topic Index Next Topic. Parameters Examples Error messages. The 4-byte print control code is created. Channel channel-number Specify which channels are used to control skipping on a report. User name Specify the user name that identifies the user profile under which the job is run. This parameter is considered hoa the job name, user name, job number, spooled file name, spooled file number, and job system name parameter requirements have been met.

Print lines that are all blank are not copied. Dear everyone, I’ve one question as below. If you have some sort of binary file, or non-readable PCL file, you will not be able to natively convert it to plain text, and may have to use an external program to do it.


Number Specify the system-assigned job number. The newly copied data replaces all old data in the member because all old records have been cleared. User Name Qualifier 3: Each assigned channel must have a corresponding line number to provide the correct positioning on a report.

Convert IBM i (AS/) data and Spool files into XML

Switch to Threaded Mode. These are pretty much your options for conversion of different type of files to plain text format.

When I need to design the form by planetperss design, I must convert the report into text 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. The only valid values for this parameter are 1 through If you don’t know, tell us what third party tool you are using to convert it.

Channel number refers to a method of determining skipping for reports. You are not logged in.