DOWNLOAD

www.cozTools.com

www.MidrangeNews.com

Contact Us

SQL iQuery Logo

SQL iQuery™  Download

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

Benefits of Licensing our Software

  • Increase Programmer Productivity
  • Modernize SQL in ways never before possible
  • Write Scripts to do tasks that would take 100's of lines of RPG and CL
  • Run SQL statements in Batch, interactively, or from the Web
  • JSON results from SQL directly to your own Web pages
  • Produce Microsoft® Excel® directly and email it to your users
  • Great support with new features being introduced regularly
  • 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 OS Download Link Downloads Notes
IBM i v7r2 and later SQL iQuery 1221 Optimized for v7r2 and later. 2COZ-IQ4 Check out the What's New log for the latest updates.
IBM i v7r1 (or later) SQL iQuery for v7.1 2368 Final Build for IBM i v7r1 (code freeze on 20 JAN 2018). This is SQL iQuery V4.5 and is identical to iQuery for IBM i v7.2 and latere except TGTRLS(V7R1M0) was used. This is our final build for IBM i v7.1. It does NOT require a license key when run on that release.
IBM i SendMail Client Our free SendMail command uses IBM i Java to send email from your IBM i system. You also need the current Java Mail client which may be downloaded here. Copy it to the IFS folder named /home/sendmail
IBM i v7r1m0 or later. IBM i Scan and Replace (SCANRPL) CL Command
Note: SCANRPL is now included in SQL iQuery.
Our free SCANRPL command can be used to search and update source members that use COZTOOLS, RPGLIB, and XTOOLS directives. It may also be used scan/replace any text in any source file member,not just our library names. For example, when upgrading from the legacy XTOOLS to COZTOOLS, you could run the SCANRPL command to change to the COZTOOLS library on /COPY statements within QRPGLESRC source.
scanrpl pattern('/COPY XTOOLS/QCPYSRC,joblog') 
       NEWVALUE('/COPY COZTOOLS/QCPYSRC,joblog') REGEX(*NO)
       SRCFILE(DEVSRC/QRPGLESRC) SRCMBR(*ALL) 
       MATCHCASE(*NO)
Regular Expression search is also supported. SCANRPL is a no-charge ("free") tool. No warranty is expressed or implied and none is given.

If you are an existing customer, you simply need to upload the IQUERY save file to your IBM i system, and then run the RSTLICPGM command.

RSTLICPGM LICPGM(2COZIQ4) DEV(*SAVF) SAVF(QGPL/IQUERY)

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, follow the link below:

SQL iQuery Installation

SQL iQuery works best with IBM i V7R2 and later. However it is backwards compatible with IBM i v7r1. (We no longer support v5r4 or v6r1 versions.) For V7R1 customers, SQL iQuery is a no-charge license program. That license expires when the IBM system running IBM i is upgraded to IBM i v7r2 or later.

SQL iQuery is packaged as an IBM i Licensed Program and must be restored using the RSTLICPGM command.

Visit our installation page for more information.

Product Information

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

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