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 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 much more powerful and easy-to-use native SQL query tool for IBM i. Modernize your Query/400 queries and skills by switching to SQL iQuery Scripts in seconds. Can you write an SQL SELECT statement? Then you already know how to use SQL iQuery for IBM i It's as sophisticated as you need it to be, and as easy to use as a CL command. Scripting your queries is as easy as writing a simple RPG or CL program.
New! Free book:
SQL iQuery Users Guide
Revised: 25 January, 2023 - 12:26

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: including RPG IV, IBM ACS, SQL iQuery, CL, RUNSQLSTM, RUNSQL and even the legacy STRSQL. Oh, and if you're running V7R2, no worries, we support all IBM i releases from V7R2 forward. Learn more about SQL Tools...

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+		Install info
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.

SQL iQuery and the iQuery Logo are trademarks of Cozzi Productions, Inc.
"Thinking in SQL" is a trademark for Cozzi Productions, Inc.