iQuery

www.cozTools.com

Contact Us

Follow us on Twitter @SQLiQuery
SQL iQuery Logo

Thinking in SQL™

SQL iQuery, SQL Tools, or COZTOOLS'86 for IBM i

Announcing SQL World™

The best value in SQL data access tools for your IBM i system

We are now offering a high-value bundle of our two flagship SQL products: SQL iQuery and SQL Tools

This bundle saves you over 25% of the OTC and 10% annually on SWMA. See pricing and availability for details.

At Cozzi Productions, we been providing the solutions for #IBMi since 1984 when we introduced our first software product (4 years before they called it "AS/400"). Today, our SQL iQuery product, a follow-on to our popular "SQL Lite" product from the mid-1990s has been creating CSV, PDF, and EXCEL from pure SQL on #IBMi since we rewrote it from the ground up in 2016. The web version of iQuery, iQuery for Web™ has been running our IBM i-hosted websites ever since.

We have partnered with PUB400.com to make our software available to all PUB400 users, while using PUB400, at no charge.

License Fee Holiday

We are waiving our up front one-time-charge (OTC) software license fee for both SQL iQuery and SQL Tools through August 31, 2022. You pay only the SWMA fee.

To take advantage of this offer, simply click the Payment button (the button with the SWMA fee) in the pricing table below and pay for your SWMA. We will then issue you a full license Key for which ever product has been selected (or both if SQL World is selected).

If you prefer to use email or receive an invoice first, then please click here to send us an email request for SQL World or one of our other offerings.

Each year, a SWMA reminder is issued, like normal, but you still don't owe that OTC up-front fee.

SQL iQuery
Powerful SQL processor to run SQL statements using a green screen CL command (RUNiQRY), the web (iQuery for Web) and within RPG IV via our provided calls to iQuery APIs. Output the results of the SQL SELECT statement to JSON, XLS, CSV, XML, PDF, TEXT, etc. and automatically email it to your customers or employees.
SQL Tools
Powerful SQL functions and stored procedures that you can use from any SQL interface, including RPG IV with embedded SQL, IBM ACS, SQL iQuery and even CL via RUNSQLSTM or RUNSQL. If you need something that makes access to API results easier, SQL Tools is the perfect solution. SQL Tools provides access to dozens of existing IBM i APIs via easy-to-use SQL functions. Learn more about SQL Tools...

Whether a 30-year Senior Software Developer, or a newbie who enjoys "code cloning" development, #SQLTools provides a consistent interface that is both familiar and portable. #SQLTools provides a consistent interface across #IBMi release levels. Whether you have some partitions running v7r2 or you've upgraded to v7r4, #SQLTools provides identical results (where available) across all supported #IBMi release levels.

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 V7R2, V7R3, V7R4+ Install info
SQL iQuery for IBM i V7R2, V7R3, V7R4+
SQL World bundle:
SQL iQuery and SQL Tools
25% savings!
V7R2 and later Use SQL iQuery and SQL Tools download links for SQL World.
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.