Contact Us

SQL iQuery Logo

SQL iQuery™  Download

Join the 338 users who have discovered how SQL iQuery solves their data access and reporting challenges with easy-to-use SQL.

For the lastest SQL iQuery news follow us on Twitter @SQLiQuery

Benefits of Licensing our Software

  • Increase Programmer Productivity
  • Output SQL SELECT results to JSON, Excel, CSV, PDF, and more!
  • Write SQL Scripts to generate the results you need.
  • Run SQL statements in Batch, interactively, or from the Web
  • Create JSON results from SQL easier than any other method and send it directly to your own Web pages.
  • Email Microsoft®; Excel® results directly to your users.
  • License per system (unlimited partitions) based on number of active CPUs ("cores")

SQL iQuery for IBM i - Download

Download Now and try it free for 60 days!

Earliest Supported IBM i Version Download Link Downloads Notes
V7R2 and later SQL iQuery V5R7 338 SQL iQuery Refresh dated 27May2020 Program ID 2COZ-IQ5. Check out the What's New log for the latest updates.
V7R2 and later SQL iQuery V5R7 - Nightly Build
Last Modified: 27May2020 Est Size: 30M -- This is a link to IQUERY.SAVF that is created periodically with fixes and updates. We use it internally and it is considered an "early experience" release. Users may experience some challenges and it may not be tested as completely as the regular product release build. If you experience any issues, please report it to us. End-Users should normally download the regular iQuery image, which is considered a stable build. Check out the fix log for the latest Information and notes on what has been fixed or changed. (To install, simply upload the IQUERY.SAVF file to your IBM i server using FTP BINARY MODE. Send it directly to QGPL and then run RSTLICPGM 2COZIQ5 DEV(*SAVF) SAVF(QGPL/IQUERY)
V7R2 and later SQL iQuery (V4R8) 4680
Optimized for v7r2 and later. Code Freeze V4R8
IBM i SendMail Client
06Apr2020 SQL iQuery supports emailing of the resultSet for OUTPUT formats PDF, Excel, CSV, XML, and others. we offer this Java-based email client at no charge to our COZTOOLS and SQL iQuery clients. The current build now includes support for email body content of up to 16M bytes. Alse the MSG (message body) parameter support the new *STMF option. When used, the new STMF parameter is used to identify the IFS file to be used as the email message body. This is very useful when sending HTML pages stored on the IFS as the email body.

Be sure to read the README source member restored into QTXTSRC in the SENDMAIL library. It contains the basic how-to install SendMail information.

Bob Cozzi's COZTOOLS
Bob's popular Cozzi Tools (COZTOOLS) software product is now available at no charge. You may download it here or visit the product website for more details.

Simply upload the IQUERY save file to your IBM i system using FTP and then run the RSTLICPGM command. FTP BINARY mode works best. We use the PC/Mac based FileZilla application for FTP and simply drag and drop IQUERY.SAVF onto the QGPL library. But there are other methods to get the file onto your server. Once uploaded, use the RSTLICPGM (Restore License Program) command to install the product as follows:


After uploaded the save file image to QGPL or another library, run the RSTLICPGM command to complete the installation.


Where x is the version, currently either 4 or 5.

After you Restore the SQL iQuery License Program you have 60 days to evaluate the product. After that a paid license is required.

If you need more help with installation, Visit our installation page for more information.

Product Information

  • Name: SQL iQuery
  • Install Library: IQUERY
  • Product ID: 2COZ-IQ5

Copyright © 2014 Cozzi Productions, Inc. All Rights Reserved.