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: Nik Tygozil
Country: Sudan
Language: English (Spanish)
Genre: Love
Published (Last): 10 January 2007
Pages: 66
PDF File Size: 6.79 Mb
ePub File Size: 4.82 Mb
ISBN: 397-6-60262-831-5
Downloads: 80776
Price: Free* [*Free Regsitration Required]
Uploader: Nikoshura

How to convert a AS spool file report to a formatted excel sheet? Contact and feedback Need support? Create a directory to FTP your file to: Then, put a file in a shared directory and test pulling that into your program.

February 27th, Sign up using Facebook. Stack Ad400 works best with JavaScript enabled. Sounds like it’s being sent to a printer automatically.

sponsored links

Sign up using Email and Password. Fill in the appropriate parameters, and press Enter.

Version Independent Operating system s: Have you tried any of them? April 13th, These are pretty much your options for conversion of different type of files to plain text format. Try doing the following before running your program: Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated as040 of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.


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

Lastly if its just querying tables you can too that using perl on a Win32 system and ump the results directly into a spreadsheet and email it. You are not logged in. If you have multiple pages, you can use the PDF Splitter to split every pages, and then use the “concatenate” option in a Send to Folder to concatenate the pages together.

Often times the customer does not have Navigator installed, so it too it difficult to get a spooled file to the PC to e-mail or send as040 our FTP servers.

Email Required, but never shown. Print Topic Switch to Threaded Mode. 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.

Are you using anything from C to call AS programs currently? Dear everyone, I’ve one question as below. Login or Sign Up.

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. Check here to start a new keyword search.


By default, once a spool file is printed it gets deleted from the system. Lots of ways to tackle this one You should try it, it may help you get rid of your current unstable tool I hope this helps. I found out the mistake. Then I can based on the text files to design the form in planetpress design. February 12th, Open a command prompt from your PC. I have been looking around but I haven’t found a small code to start from there, I been searching around and haven’t found anything close.

Today’s Posts Member List Calendar. I have the same problem. It also seems like there are some classes to support FTP interaction in C. At the command prompt command line, enter C: There are also lots of commercial packages that can do this stuff for you automagically.

ibm midrange – How to Generate Spool File in AS? – Stack Overflow

I wasn’t allowed to call the APIs. Objectif Lune, Montreal, Qc. Thank you very much!