AS400 SPLF TO PDF
May 26, 2021 | by admin
Any questions relating more to a PC type environment. This could be PC, Servers (both LINUX and WINDOWS). Prepare the SAVF a. On a PC, open IBM System i Access for Windows. b. Start a session with the AS/ server where spool file to be exported is located. c. Assuming you’re correct and that the program creates a spool file Sounds like it’s being sent to a printer automatically. By default, once a.
|Published (Last):||4 August 2009|
|PDF File Size:||13.43 Mb|
|ePub File Size:||12.33 Mb|
|Price:||Free* [*Free Regsitration Required]|
Sign up or log in Sign up using Google. 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.
The AS spool report is aplf.
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 None of the above, continue with my search. United States English English. But when i run the command i am not able to get spool file for that run of command. How to convert a AS spool file report to a formatted excel sheet?
IBM FTP a Spooled File to PC – United States
Resolving the problem Often times the customer does not have Navigator installed, so it makes it difficult to get a spooled file to the PC to e-mail or send to our FTP servers. Tl like it’s being sent to a printer automatically.
Are you using anything from C to call AS programs currently? Sign up using Facebook. Have you tried any of them? Lastly if its just querying tables you can do that using perl on a Win32 system and ump the results directly into a spreadsheet and email it. Assuming you’re correct and that the program creates a spool file Thank you very much! It also seems like there are some classes to support FTP interaction in C. Post as a guest Name.
Converting a spooled file to PDF
You are not logged in. I found out the mistake. Print Topic Switch to Threaded Mode. We have a requirement, where in the AS spool file report needs to be converted to a formatted excel sheet and mailed to the respective people. Get the file from the iSeries: I have attached a sample of how the excel sheet should come up All my answers were extracted from the “Big Dummy’s Guide to the As” and I take no responsibility for any of them.
I have been building all of my reports with 3 options Change to that directory: Post as a guest Name. Sign up using Email and Password. By default, once a spool file is printed it gets deleted from the system.
You will be prompted for your iSeries user ID and password. The next screen contains the attributes.
But to capture jobs automatically, you must use PlanetPress Workflow. Then, put a file in a shared directory and test pulling that into your program. Contact and ws400 Need support?
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.