AS400 DATABASE FILE EXPORT AND IMPORT SOFTWARE

CoolSpools Database

Easily extract and convert IBM i (AS400) database files to Excel, XML, HTML, Text, CSV and save Query output and SQL selection results in any format with CoolSpools Database.

CoolSpools Database is a module of the complete CoolSpools Suite. In addition to exporting database files from IBM i (AS400), it allows you to import from Excel to an IBM i (AS400) database and validate an XML document against an XSD schema.

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 database spool file transfer and reporting
IBM i AS400 database spool file transfer and reporting

Export database files from AS400, and import information to a database from Excel.

Easily extract data from AS400 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.

Download

Buy CoolSpools Database

Buy Coolspools Database as a stand-alone module for $1155 per LPAR.

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

CoolSpools Database Features:

  • Extract data from your IBM i (AS400) databases directly or using SQL or Query.
  • Import data into your IBM i (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 AS400 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 IBM i (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 from AS400 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.

CoolSpools Database 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 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.

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

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.

CoolSpools Guides, FAQ’s and Documentation

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…

Spool file exit program with Coolspools

FAQ: Coolspools Exit Programs

How do I write an exit program for CoolSpools to call?

Convert spool to pdf

How Spool File Converters Can Help Your Business

Could you be making better use of your data extracts? Maybe you’re wasting time performing tasks…

XML file

FAQ: Import XML to IBM i Database

How can I use CoolSpools to import data from an XML file to my IBM i Database?

FAQ: CoolSpools and H.A. / Replication

We’re using a High Availability system that replicates our objects and data to a backup system.…

coolspools CHKXML

CHKXML – Check XML files using XSD schema

CoolSpools recently introduced command CHKXML runs natively on the IBM i platform to validate the…

QUERY/400

Distribute Your Existing QUERY/400 Reports as Excel Spreadsheets

An IBM i (AS/400) users guide to distributing existing QUERY/400 reports as Excel Spreadsheets from…

patrick amoy - IBM I tasks

3 Everyday IBM i Tasks Made Easy

If you work in an IBM System i, AS/400 or iSeries environment, there are many applications on the…

scott winterroth

Migrating from IBM i 5.4 (V5R4) OS

If you are migrating to V6R1 or IBM i V7 of the operating systems prior to the deadline later this…

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