Thinking in SQL™
SQL iQuery, SQL Tools, or COZTOOLS'86 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.
SQL World™
2 products, 1 license
At Cozzi Productions, 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 iQuery and SQL Tools are included in the SQL World bundle for one low price for your IBM i environment.
New! Free book:
SQL iQuery Users Guide
Revised: 25 January, 2023 - 12:26
Pricing and Availability
Use this table to purchase our software and support options, or to download one of our awesome products.
Product | One-Time-Charge (OTC) | SWMA (support) | Supported IBM i Release Levels | Download | Installation Info |
SQL Tools for IBM i | See SQL World pricing | V7R2, V7R3, V7R4+ | Install info | ||
SQL iQuery for IBM i | See SQL World pricing | V7R2, V7R3, V7R4+ | |||
SQL World bundle: SQL iQuery and SQL Tools 25% savings! |
|
V7R2 and later | Use SQL iQuery and SQL Tools links. | ||
COZTOOLS '86 OSE | Open Source No-Charge |
N/A | V7R2, V7R3, V7R4+ | Install info |
If you've already purchased SWMA and need help, or if you need assistence with a purchase:
SQL Tools 2021 is our latest product. It picks up where the standard set of SQL Services leaves off, providing dozens of new SQL Functions and Procedures to make you do your job faster than ever before! Visit the SQL Tools online Docs page to read more about each available SQL Tools function. Then visit the Buy Now page and get started!
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 Productions, Inc. All Rights Reserved.
- SQL iQuery and the iQuery Logo are trademarks of Cozzi Productions, Inc.
- "Thinking in SQL" is a trademark for Cozzi Productions, Inc.