How do I save a spool file in AS400?

Use the Work with Spooled File (WRKSPLF) command to list the spooled files. Use option 2, Change Spooled File Attributes (CHGSPLFA) command to move the spooled files you want to save to the output queue you created. Use the Save Object (SAVOBJ) command to save the spooled file data.

How do I create a spool file in AS400?

Steps to capture spool file

1. Create new ‘OUTQ’
2. Store spool file(s) in new ‘OUTQ’
3. Create save file (‘SAVF’)
4. View the created SAVF to make sure the spool file is successfully stored in the SAVF.
5. Export ‘SAVF’ file to Windows client PC.

How do I convert AS400 spool to excel?

On your IBM i partition, create the spooled file you want to export into Excel. Using System i Navigator (OpsNav), extract and save your spooled file data as a text file (. txt). Open your text file in Excel 2010 and use Excel’s Text Import Wizard to import your spooled file text into an Excel spreadsheet.

What is spool file in AS400?

AS400 Spool File Status Test. Spooling is a system function that saves data in a spooled file (or printer output file) for later processing or printing. When spooling is used, the spooled files are created from the application program, from a system program, or by pressing the Print key.

How do I convert a 400 file to Excel?

To send a data file to the host system:

1. Highlight the Microsoft Excel file (. XLS) in the left hand, client side window and right click.
2. Select iSeries File Transfer from the pop-up menu.
3. The XLS File and the XLS Filename. OUTFILE will be parsed, the data file will be created and uploaded to the AS/400.

How do you clear OUTQ in as400?

To clear an output queue, follow these steps:

1. Expand Work Management > Output Queues.
2. Right-click the output queue that you want to clear, and click Clear.

How do I copy a spool file?

The Copy Spooled File (CPYSPLF) command copies the data records in the specified spooled file either to a user-defined physical database file or to a stream file. This allows the use of spooled files in applications using microfiche, data communications, or data processing.

Can you export from as400 to excel?

Depending on which toolset you have available, you can export the resultset of the query to a delimited file, (if necessary performing any codepage conversion that may be needed), and then import that delimited file to Excel.

What is spool file?

A spooled file holds output data until it can be printed. The spooled file collects data from a device until a program or device is able to process the data. A program uses a spooled file as if it were reading from or writing to an actual device.

How do I export data from mainframe to Excel?

Convert the file to CSV on the mainframe (for example, via a REXX exec, a z/OS UNIX shell script, or a Lua4z program), and then insert that CSV file into Excel via FTP. You do not need to transfer the CSV file to your PC’s file system and then, as a separate step, open it in Excel.

Can AS400 export to Excel?

How to create a spool file from as / 400 to a…?

Type ftp < iSeries_ IP_address >, where address is the IP address of the iSeries (AS/400) server. Enter User name and Password if necessary, and press Enter after entering each credential. Type bin and then press Enter to put ftp session into binary mode. Use the cd command to change to the directory where the SAVF file is saved.

How to convert a AS400 report to a formatted Excel sheet?

1. Use CPYSPLF to copy your spoolfile into a physical file. 2. Read this pyiscal file and split the rows into columns. 3. Create an excel sheet with the appropriate colums and heades and fill it using CGIDEV2. Re: How to convert a AS400 spool file (report) to a formatted excel sheet?

How to convert a spool file to an Excel sheet?

You may check if it is possible and sufficient to use CGIDEV2 creating an Excel-XML-Document. 1. Use CPYSPLF to copy your spoolfile into a physical file. 2. Read this pyiscal file and split the rows into columns. 3. Create an excel sheet with the appropriate colums and heades and fill it using CGIDEV2.

When do I need to capture a spool file?

Capturing the spool file may prove useful in the analysis and troubleshooting of print errors and anomalies in AS400 and other system environments. You may be requested to provide a SAVF file for diagnostic purposes. This file must be captured if a valid network trace is not possible, or if the problem is observed when printing from the host only.