CoolSpools Database

CoolSpools helps you give your users and customers the right information, at the right time, and, just as importantly, in the right format.

CoolSpools runs entirely on the IBM i and does not need a PC to produce Excel files or XML documents etc., though these can then be easily accessed from a PC.

All database file types supported, including:

• physical files
• logical files
• DDM files
• CoolSpools Database also supports:
• Queries (*QRYDFN)
• QM Query (*QMQRY)
• SQL
• SQL in source file

Allowing you to save the output from any of those in any supported file format.

So, this means you can run a query on the AS400 and save the output as an Excel spreadsheet! What’s more, if you’ve got CoolSpools Email, you can email that spreadsheet to your users or customers too.

Other features include:

• Field selection and sequencing. Just list the fields you want in the order you want them.
• Alternatively, just list the fields you don’t want:
• Record selection and sequencing
• Specify a query selection string to define the selection criteria for records you want.
• Defined sort keys to control the sequencing of the output you want.

Use styles to control the appearance of Excel rows and cells. Use colours, fonts, shading, borders etc. Define conditional formatting rules, for example, to colour high values red or low values green.

Generate XML documents, schemas and stylesheets on AS400 / IBM i

With CoolSpools Database you can:

• Generate an XML document from your files or queries.
• Use the XML to interface your data into other systems.
• Automatically generate a DTD or XSD schema.
• Automatically generate an XSLT or CSS stylesheet.

Additional links related to setting up and managing email on the IBM i can be found on our Email Setup page.