Spooled File to PC and back to AS/400
Good morning,
Is there a way to transfer spooled file output to a PC or server for storage and if necessary, at a later date, transfer it back to the AS/400? We have alot of spooled file output on our system that is out of date and I was wondering if there was a way to save it off to a PC or server and if it needed to be reprinted in the future, transfer it back. Thanks!
Software/Hardware used:
Software/Hardware used:
ASKED:
May 12, 2006 8:55 AM
UPDATED:
May 23, 2006 10:32 AM
Answer Wiki:
In V5R4, there is a facility that I have not tried yet; the SAVSPLF command (I may have the spelling wrong). Before that, there is a similar feature in the QUSRTOOLs called SAVRSTSPLF. Check out the user tools; be user you have them installed since these are optional (and free) from your original OS/400 install media.
To see all answers submitted to the Answer Wiki: View Answer History.
In V5R4, there is a facility that I have not tried yet; the SAVSPLF command (I may have the spelling wrong). Before that, there is a similar feature in the QUSRTOOLs called SAVRSTSPLF. Check out the user tools; be user you have them installed since these are optional (and free) from your original OS/400 install media.
You can use Operations Navigator to move the spooled file to a PC folder,creating a “.txt” file. You can then use Word to print it directly from the PC.
You can try infoprint as well. It allows you to spool straight to a file server directory in PDF format.
We use a very affordable product from Ariadne Software call CoolSpools. Their product converts all types of spooled files to the IFS in the following formats PDF, XLS, HTML, TXT, CSV, RTF, TIFF. You can also archive the spool to the IFS and restore it later.
Yes, there are several good ways to move a spool file to a PC. But how do you get the spool file back on the AS400 and keep the formatting?
There is a product called SpoolFlex that allows you to convert your reports to PDF AND IT CAN also convert those PDF files back to an iSeries AS/400 spooled file. Although most companies prefer to keep the spooled files on their file server as PDF files. I do not know of any other product that can convert the PDF files back to iSeries AS/400 spooled files.
They offer a free 15 day trial
http://www.drvtech.com
We wrote an application to do this. We use the copy spooled file command with CTLCHAR(*PRTCTL). This gives you the skips and spaces for the spooled file. We create a multi-member file with same name as the outq. You can then off load this file using whatever method you choose. We use a generic program to re-print the reports. We use the PRTCTL keyword on the printer file spec to do the formatting. The downside is you cannot do this for *IPDS or *AFPDS spooled files.