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):||10 January 2007|
|PDF File Size:||6.79 Mb|
|ePub File Size:||4.82 Mb|
|Price:||Free* [*Free Regsitration Required]|
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.
Sign up using Email and Password. Fill in the appropriate parameters, and press Enter.
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!