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

Delivering AS400 data transformation efficiency

Apache Log4j Vulnerability

The CoolSpools application is not impacted by the Apache Log4j vulnerability CVE-2021-44228

Coolspools variables

FAQ: Spool Admin Substitution Variables

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

Convert Spool to Excel with CoolSpools

How to Convert IBM Spool to Excel with CoolSpools

The CoolSpools range of AS/400 solutions includes a powerful spool file converter that can output…

FAQ: CoolSpools and Excel

I’m running CoolSpools V6, CoolSpools PLUS, CoolSpools V5 or Slipstream V4 and am having problems…

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 its time to upgrade

It’s Time to Upgrade Your Best-Kept Secret: IBM i

IBM just released a new version of IBM i 7.4 — with some significant new capabilities.

AS400 adding images in PDF reports

FAQ: Including images in PDFs

My document prints on a pre-printed form and I need to see that inside the PDF. Can CoolSpools do…

IBM IOS update and Coolspools

FAQ: CoolSpools and IBM i OS Upgrades

I’m upgrading to IBM i V6R1M0-V7R5M0, do I need a special version?

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