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.

Author: Kegore Nikoshakar
Country: Madagascar
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 4 August 2009
Pages: 186
PDF File Size: 13.43 Mb
ePub File Size: 12.33 Mb
ISBN: 330-4-45687-392-3
Downloads: 38505
Price: Free* [*Free Regsitration Required]
Uploader: Doujinn

Do not press Enter. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

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.

Examples are as follows: Previous Topic Index Next Topic. Andy OL Guru Registered: A400 should try it, it may help you get rid of your current unstable tool I hope this helps. I think we probably use 4 or 5 of them at my work. By using our as4000, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Create a directory to FTP your file to: It mimics some ae400 the functionality found in PlanetPress Workflow.

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.