Download the datasheet to learn more about how CoolSpools can deliver increased efficiencies to your IBM i environment. There is no polling involved so the system loading is minimal.
In batch mode CoolSpool Admin commands let you select sets of spool files to work on using various criteria and allows you to apply a command or sequence of commands to each of those selected spool files in turn. It includes features to select spool files by user, outq, user data, form type, and creation date. Plus many more user-defined options. See all case studies Want to know how the CoolSpools Suite could benefit your business?
Complete the form below and one of our team will get in touch. With CoolSpools Converter you can give your users reports in the format they want. Already evaluated CoolSpools Converter? Buy now. Multi-licence discounts are available by application. Annual maintenance is free in the first year after purchase.
Manage data extracts with a single command CoolSpools Software helps you give your users and customers the right information, at the right time, and, just as importantly, in the right format. For example, if your spooled file is a batch of documents invoices, statements etc. You can even tell it to email each separate PDF to a different email address or addresses.
CoolSpools Spools Converter can also append a new worksheet to an existing spreadsheet when converting a spooled file to Excel format. We know of no other IBM i product that can do this. CoolSpools Email lets you do just that. You can now distribute reports and documents to users and customers as email attachments.
Our AS email tool integrates with our Database and Converter solutions to allow you to easily transform AS data into superbly formatted reports that can be emailed individually or as multiple attachments.
Your emailed reports from AS can also be a part of your document and reporting workflow thanks to our bundled CoolSpools Admin tool — allowing you to deliver scheduled and trigger-based email automation with your own scripts. CoolSpools ISV partners understand the benefits gained through successful strategic partnering, and are committed to provide industry-leading solutions.
Read More. Case Studies. To see it in action, request a demonstration or download the complete suite free for 30 days. Our free trial download includes the full suite of software with all features enabled. We also provide complete support and guidance so you can get the most from the software during your trail. Our aim is to help you fully evaluate CoolSpools for your specific requirements.
There is no polling involved so the system loading is minimal. In batch mode CoolSpool Admin commands let you select sets of spool files to work on using various criteria and allows you to apply a command or sequence of commands to each of those selected spool files in turn. It includes features to select spool files by user, outq, user data, form type, and creation date. Plus many more user-defined options. Complete the form below and one of our team will get in touch.
CoolSpools Suite is offered at a massive discount compared to purchasing each module individually. Download CoolSpools. Buy CoolSpools now. Buy the full suite today. I filtered out the blanks and the dashes used to underline with grep and tr like this grep -v -- myfile. Otherwise, it would depend on the location where you are executing the script.
Show 6 more comments. If you are using BobC BobC 3, 1 1 gold badge 11 11 silver badges 14 14 bronze badges. Does anyone know how to you turn off echo, the obvious "set echo off" doesn't seem to work with this? Assuming that this is because you are executing a script and writing to a file, you should just "set termout off" — BobC.
So, I use the following syntax: set colsep ' ' set echo off set feedback off set linesize set pagesize 0 set sqlprompt '' set trimspool on set headsep off spool output. I don't use sed for format the output file. Hallison Batista Hallison Batista 4 4 silver badges 4 4 bronze badges. I see a similar problem Karlos Karlos 2 2 silver badges 2 2 bronze badges.
What is the extra outer select x for? This should work without it. SQL Developer Version 4. Doc Doc 4 4 silver badges 12 12 bronze badges.
Nice catch on the underline option, needed that one. It would help anyone who may want to view the csv file, and figure out what they are looking at, etc It's crude, but: set pagesize 0 linesize trimspool on feedback off echo off select '"' empno '","' ename '","' deptno '"' as text from emp spool emp.
Tony Andrews Tony Andrews k 20 20 gold badges silver badges bronze badges. You can explicitly format the query to produce a delimited string with something along the lines of: select '"' foo '","' bar '"' from tab And set up the output options as appropriate.
FrustratedWithFormsDesigner Rob Heusdens Rob Heusdens 4 4 bronze badges. The trim is unnecessary. For those of us still stuck in the past with I do it this way because it handles commas in the data. I turns them to semi-colons. Charles Stepp Charles Stepp 21 2 2 bronze badges. See bash script below:! Larry R. Irwin Larry R. Irwin 5 5 bronze badges.
Jared Still Jared Still 7 7 bronze badges. Rajeesh Madambat 1, 1 1 gold badge 9 9 silver badges 16 16 bronze badges.
0コメント