AS400 SPOOL FILE AUTOMATION TOOLS

CoolSpools Admin

Get complete control over your IBM i (AS400) spool file data. CoolSpools Admin lets you automate the conversion and distribution of spool files. PLUS, CoolSpools Admin is now FREE with the complete CoolSpools suite.

Download and evaluate the complete CoolSpools Suite free for 30 days.

Request a one-to-one demonstration from an IBM i specialist:

Book a demo
IBM i AS400 admin: delete, save, copy, clear spool files
IBM i AS400 admin: delete, save, copy, clear spool files

Automate your spool file conversion and distribution

With CoolSpools Admin, spool files can be processed automatically as soon as they are created. The module lets you define spool file monitors that “watch” nominated output queues for new files being created. With CoolSpools Admin, there is no polling involved, so the system loading is minimal.

CoolSpools Admin lets you manage:

  • Automatic conversion, distribution and management of spool files
  • Work with spool files online
  • Select batches of spool files and run the same command against each

New spool files are evaluated against spool file rules that you define to determine what type of spool file has been found and what should be done. Those spool files can then be automatically processed by running:

  • Standard, customisable options e.g. 10=Convert to PDF or 21=Email as Excel
  • User-defined options
  • Command strings, e.g. to call a program to archive the spool file
  • Your scripts.

In batch mode, CoolSpool Admin commands let you select sets of spool files to work on using various criteria and allow you to apply a command or sequence of commands to each of those chosen spool files in turn. For example, you can select all spool files over 30 days old, archive them, and delete them with a single command.

CoolSpools Admin contains a compelling and customisable “work-with” screen for spool files in the style of PDM that lets system operators and users manage, convert and email the spool files they produce. It includes features to select spool files by user, user data, form type, and creation date. Plus, there are many user-defined options.

CoolSpools Admin Specifications

CoolSpools helps you give your users and customers the correct information at the right time and, importantly, in a valid format.

While CoolSpools Spool Converter gives you the functionality to convert an IBM i spooled file to a variety of formats, such as PDF and Excel, and CoolSpools Email lets you email those files to users and customers, CoolSpools Spool Admin provides an infrastructure that enables you to manage to convert, multiple and distribute spooled files, either:

Realtime

WRKSPLFPDM (Work with Spooled Files PDM-style) is a familiar, straightforward, compelling, and customisable “work-with” screen for spooled files that lets system operators and users manage the conversion and email the spooled files they produce. Includes features such as:

  • Select spooled files by user, outq, user data, form type, creation date etc.
  • User-defined options
  • Customisable standard options, e.g. 10=Convert to PDF, 21=Email as Excel etc.
  • Sort by name or date
  • F13=Repeat option to the end of the list

In batch

The RUNSPLFCMD (Run Spooled File Commands) command lets you select spooled files to work on using various criteria and apply a command or sequence of commands to each of those spooled files in turn. For example, select all spooled files on a given output queue and convert all to PDF with one order. Or select all spooled files over 30 days old, archive them, and delete them with a single command.

Automatically

Process spooled files automatically as soon as they are created. CoolSpools Spool Admin lets you define spooled file monitors that “watch” nominated output queues for new files being created. No polling involved: system loading is minimal. New spooled files that are detected are evaluated against spooled file rules that you define to determine what type of spooled file has been found and what should be done. Those spooled files can then be automatically processed by:

  • running a standard, customisable option such as 10=Convert to PDF or 21=Email as Excel.
  • running a user-defined option.
  • running any command string, which might call a program, move, delete, send, convert or archive the spooled file etc.
  • any combination of the above in the form of a user-written spooled file script.

Download CoolSpools FREE for 30 days

Take a free test drive of the entire CoolSpools Suite, including converter, database, email and admin FREE for 30 days.

Download CoolSpools Suite

CoolSpools Guides, FAQ’s and Documentation

FAQ: IBM i email troubleshooting

My emails are being sent/aren’t being delivered: how can I work out why?

Productivity - IBM I

IBM i Information Management Made Easy

Are you getting the most from your System i environment? Is your data managed, extracted and…

Coolspools and encrypted files

FAQ: Using encrypted zip files

Can CoolSpools password-protect an Excel file?

edwin andrade

The Power of iSeries PDFs (And The Easy Way to Create Them)

If you work in an IBM iSeries, System i or AS/400 environment, creating PDFs has got even easier!…

FAQ: Splitting/bursting spooled files

My spooled file contains multiple documents (invoices, statements etc.) that need to be sent to…

Sunset Image

Withdrawal of IBM Db2 Web Query

IBM have announced the withdrawal of IBM Db2 Web Query for i. Is CoolSpools affected, or can it be…

FAQ: Giving your files meaningful names

I want to give my files a meaningful name. How can I do that?

Coolspools variables

FAQ: Spool Admin Substitution Variables

What are CoolSpools Spool Admin substitution variables, how and where can I use them and how to…

Spring4Shell Vulnerability

Apache ActiveMQ Vulnerability

The CoolSpools application is not impacted by the Apache ActiveMQ vulnerability CVE-2023-46604

All CoolSpools articles

REQUEST A CALL BACK

Would you like to see how CoolSpools Suite could modernise data management on your your IBM i?

Complete the form below and one of our technicians will get in touch.

CoolSpools logo