iQuery

Contact Us

Follow us on Twitter @SQLiQuery
SQL iQuery Logo

Thinking in SQL™

SQL iQuery, SQL Tools, or COZTOOLS for IBM i

Tired of using a deprecated 1980s-style Query 400 for your IBM i reports? So are we. That's why we created SQL iQuery.

Wish you could run some of those cool SQL functions on V7R2 or V7R3? So do we. That's why we created SQL Tools.

SQL World™

2 products, 1 license

At Cozzi Research, we been providing the solutions for #IBMi since 1984 when we introduced our first software product for this platform (4 years before they called it "AS/400").

New! You may try out our SQL software on a live IBM i server in the cloud, via our partner website PUB400.com at no cost to you. This allows anyone from the average developer to the CIO to check out SQL Tools and SQL iQuery on a Power server before you buy, avoiding the hassle that sometimes occurs when attempting to install 3rd-party trial software. It is so easy to get going with a PUB400.com account, you'll be up in minutes.

SQL World
Our industry-leading SQL products are now one bundled offerring: SQL World
SQL iQuery and SQL Tools are included in the SQL World bundle for one low price for your IBM i environment.
SQL iQuery

SQL iQuery is powerful and easy-to-use native alternative to the legacy Query/400.

SQL iQuery is a SQL-based tool for IBM i that provides a high-level interface for querying and manipulating IBM i data. It allows developers to write SQL statements to extract, insert, update, and delete data from IBM i database tables, and provides a set of built-in functions for performing complex data manipulations and transformations.

SQL iQuery provides a number of benefits over traditional IBM i programming methods, such as faster development time, improved maintainability, and increased performance. It also integrates seamlessly with other IBM i development tools and can be used in combination with other programming languages and platforms to create complex, multi-tier applications.

SQL iQuery is typically used by developers and database administrators who are looking for a more efficient and flexible way to work with IBM i data, and is widely adopted in the IBM i community.


New! Free book:
SQL iQuery Users Guide
Revised: 14 November, 2023 - 12:42
SQL Tools

The Professional Db2 for i SQL Extension Pack for your IBM i system. SQL Tools is a powerful, professionally written and optimized collection of SQL functions and stored procedures that you can run from any IBM i SQL interface. SQL Tools picks up where "IBM Services" (formerly SQL Services for IBM i) ends, providing you with all the capability you need to access important IBM i information using any SQL interface.

SQL Tools is a product that combines the capabilities of the IBM i APIs, Db2 database, middleware and development environment.

The product provides a set of SQL-based tools to enhance the functionality and usability of IBM i databases.

It includes features such as improved SQL performance, enhanced data integrity, and support for modern development methodologies.

It is designed to be used by Developers, Database Administrators and Systems Admins, by simplifying the process of working with IBM i interfaces, such as database, APIs, and system information using an SQL interface.

Learn more about SQL Tools...

Pricing and Availability

Licensing Choices
Product One-time fee (OTC) Subscription Supported IBM i Release Levels Download Installation Info
SQL Tools for IBM i $2095 (OTC) $695/annual subscription V7R2 and later Install info
SQL iQuery for IBM i $1995 OTC per system
$4995 (OTC) site-license with/Unlimited servers/partitions per company
V7R2 and later
COZTOOLS Free Edition Open Source
No-Charge
N/A V7R2 and later (V7R1 version available on request)

SQL Tools is now offered to our customers using either of the following license models:

  1. One-time charge (OTC)
  2. Annual Subscription

The one-time charge (OTC) model includes support and updates for up to six (6) months from date of purchase. The subscription model includes support and updates for as long as you have a paid-up subscription active. It also includes transfers for system upgrades.

To initiate your purchase, send us an email with your IBM i Version and System Serial Number (DSPSYSVAL QSRLNBR) by clicking here ⇛

If you've already purchased SWMA and need help, or if you have further questions regarding a purchase:

SQL Tools provides some of the most productive and useful IBM i SQL functions available. With over 150 SQL functions you can now access IBM i API data using good old SQL right from within your RPG IV code or SQL processor (such as ACS, STRSQL and SQL iQuery). Visit the SQL Tools online Docs page to read more about each available SQL Tools function. Then visit the

SQL iQuery is our most popular #IBMi software ever. If you tried to run the SQL SELECT statement from Command Entry and view the results, you found that the IBM RUNSQL and RUNSQLSTM commands just don't stand up. There are myriad techniques to move results into files using all kinds of nonsense. I read those techinques in articles all the time. But with SQL iQuery you can simply run the SELECT and any other SQL statement from command entry, CL, or where ever. Just type in something like: runiQry 'select * from qiws.qcustcdt' <enter> and get the results right there on the screen. Or using the OUTPUT parameter, redirect the output to a number of formats including: EXCEL, PDF, TXT, CSV, JSON, XML and more. The powerful SQL iQuery Script language is nearly an interpretive RPG-free language that your programmers can start using immediately.

COZTOOLS '86 is probably already on your system. It has been mimicked by myriad 3rd party software houses and indepents for decades. First introduced as Q38 Programmer Utilities back in 1986, this package has been kept up to date for decades. It was rebranded RPGTOOLS for a while and has been known as "Cozzi Tools" for the last two decades. Now, Cozzi Tools'86 (pronounced "cozy") is a no-charge product, with source code included! Visit the Cozzi Tools page for more info.

  • Copyright © 2014 Cozzi Research All Rights Reserved.
  • SQL iQuery and the iQuery Logo are trademarks of Cozzi Research
  • "Thinking in SQL" is a trademark for Cozzi Research