CoolSpools Database

IBM i / AS400 Database File Extraction and File Conversion Software

Download Free Trial
CoolSpools Database

Export database files from your AS400 / IBM i

Rapidly extract, convert and distribute IBM i / AS400 data in report formats and integrate with third party systems.

Rapid IBM i / AS400 data extraction and conversion to Excel, PDF, XML, Text, CSV, XML and more with CoolSpools Database.

Database is a module of the CoolSpools Suite and is available separately if you only need to convert database files to Excel, XML, HTML, Text, CSV – and save query output and SQL selection results in any of those formats.

CoolSpools Database offers IBM I / AS400 file conversion.  It distributes IBM i data quickly, conveniently and cost-effectively – and it extracts data from IBM i AS400 database files to a variety of formats, including Excel, XML and fully searchable PDF’s.

CoolSpools Database will also allow you to import from Excel to a database file and validate an XML document against an XSD schema.

Free Trial

CoolSpools Database and the full CoolSpools Suite are available to download free for 30 days.


Already evaluated CoolSpools Database?

Buy CoolSpools Database now from $1065 per LPAR.


Multi-licence discounts are available by application.
Annual maintenance is free in the first year after purchase.

CoolSpools Database Features:

  • Extract data from your AS400 databases directly or using SQL or Query
  • Import data into your AS400 databases from Excel spreadsheets
  • Record and field selection and sequencing
  • Use styles to control the appearance of Excel rows and cells
  • Use colours, fonts, shading, borders etc. and define conditional formatting rules
  • Generate XML documents, schemas and stylesheets
  • Interface your data into third-party systems
Manage IBM Data Extracts

Manage data extracts with a single command

CoolSpools Database distributes queries, reports and database extracts to your users and customers in electronic form. It avoids the need to run file transfers from a PC by creating Excel files etc. directly on your AS400, letting you generate data extracts as part of your batch jobs, just by running a single command.

All database file types are supported, including physical, logical and DDM files.

CoolSpools Database also supports input from SQL statements, SQL scripts and queries, allowing you to run a query and save the output as an Excel spreadsheet.

Generate XML files with reliability and precision

The use of XML is becoming increasingly widespread so the ability to generate XML from Spool files and database files is a major advantage to AS400 users.

With CoolSpools the process of creating XML files from your AS400 data is simple and reliable as everything happens on the AS400 platform.

BM iSeries generate xml files

CoolSpools Database Details & Specifications

CoolSpools Database Details & Specifications

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

CoolSpools Database extracts data from IBM i database files (physical, logical or DDM files) to a variety of formats, including:

  • Excel
  • XML
  • Fixed-width text
  • CSV (and other delimited formats such as TSV)
  • HTML
  • PDF (with our Spool Converter)

CoolSpools Database can also work the other way round: its CVTDBFXL (Convert Excel to Database) command can extract the cell contents of an Excel spreadsheet and write them to a database file in a standard “outfile” format (just like IBM commands such as DSPOBJD) so that the information from the spreadsheet can be easily processed by your applications.

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.

Admin Icon

CoolSpools Suite now comes with CoolSpools Admin included FREE!

Automate your spool file conversion and distribution.

With CoolSpools Admin, spool files can be processed automatically as soon as they are created, as the system lets you define spool file monitors that “watch” nominated output queues for new files being created. 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.

CoolSpools Admin contains a highly powerful and customizable “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, outq, user data, form type, and creation date. Plus many more user-defined options.

CoolSpools Admin is now included free with CoolSpools Suite.

Learn more about CoolSpools Admin

Download the CoolSpools datasheet

CoolSpools is a powerful but highly cost-effective information management toolkit for IBM i.
CoolSpools helps you give your users and customers the information they need, when they need it, how they need it.

Download the datasheet to learn more about how CoolSpools can deliver increased efficiencies to your IBM i environment.

Latest CoolSpools Guides, FAQ’s and Articles

CoolSpools License Transfer

Guide: CoolSpools License Transfer

Everything you need to keep CoolSpools running after a hardware or operating system upgrade

Read More

CoolSpools PDF/A

FAQ: Database Variables

What are CoolSpools Database variables?

Read More

Overlay alignment in CoolSpools

FAQ: CoolSpools and Overlay alignment

Why doesn’t my overlay line up properly?

Read More

Spool File Converter Turbo

17 Ways Spool File Converter Turbo-Boosts AS400 Systems

Creating PDFs just got a whole lot easier! Why manually create PDFs when CoolSpools can automate…

Read More

iseries xml

Communication in the modern world – converting iSeries files to xml

Converting important data from your iSeries system to be shared across intranets, the world wide…

Read More

All CoolSpools articles

Want to know how the CoolSpools Suite could benefit your business?

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

CoolSpools logo
Ariadne Software Ltd.
2 The Beeches
Beech Lane
Wilmslow
Cheshire
SK9 5ER
United Kingdom
Contact us:
Help Desk portal
+1 (888) 228 2415
+44 (0)1625 547 962
sales@ariadnesoftware.co.uk