SQL iQuery™ Download
Join the thousands of #IBMi users who have experienced the power and simplicity of SQL iQuery
For the latest SQL iQuery news follow us on Twitter @SQLiQuery
SQL iQuery for IBM i - Download and Trial Request Page
Note: IBM i v7r3 or later is required for SQL iQuery. We also have a no-charge IBM i v7r2 compatible version available that allows customers with older IBM i installations to take advantage of SQL iQuery for free until they migrate to V7R3 or later. That V7R2 version is available for direct download below.
| Earliest Supported IBM i Version | Download Link | Downloads | Notes |
|---|---|---|---|
| SQL iQuery release notes | Licensed Program 2COZ-IQ7 What's New log. Check it out for the latest updates and features added to SQL iQuery. | ||
| V7R3 and later | SQL iQuery - V7R3+ Download | Last Modified: 14Nov2023 Est Size: 36M -- This is a link to IQUERY.ZIP for your use. It is both a live version and has a built-in 17-day trail license. It is refreshed periodically with fixes and updates. This is the version we use internally. It is considered an "early experience" release. Some users may experience challenges verses the regular product release. However those instances are rare. If you experience any issues, please report it to us. | |
| V7R2 | SQL iQuery - V7R2 Download | Dated: 13Nov2023 IBM i v7r2 compatible build of SQL iQuery. This is the same code base as our V7R3 build of iQuery V6R3 but compiled with TGTRLS(V7R2M0). It has some IBM i release-dependent limits, but nothing important. It has no license key requirements when run on V7R2. This build works on V7R2 and later but when used on V7R3 or V7R4 it has the same licensing requirements as our V7R3 build. | |
| IBM i SendMail Client |
[an error occurred while processing this directive]
SQL iQuery supports emailing of the resultSet for OUTPUT formats PDF, Excel, CSV, XML, and others. It supports IBM SNDSMTPEMM and this Java-based email client we call SENDMAIL. SENDMAIL is available at no charge to our COZTOOLS and SQL iQuery clients.
The current build includes support for email body content of up to 16M bytes. Also the MSG (message body) parameter supports 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 www.cozTools.com for more details. |
Installation
Step 1: Upload the IQUERY.SAVF save file to your IBM i system using FTP (binary mode) and then run the the following steps. For FTP we use the PC/Mac App FileZilla and simply drag and drop IQUERY.SAVF onto the QGPL library. But there are other methods to get the file onto your server:
Step 2: If you have an existing installation of SQL iQuery (use GO LICPGM option 10 to see if it is installed) you must delete it before installing a new
version or refreshed update.
DLTLICPGM 2COZIQx
Where the x in 2COZIQx is either 5, 6, or 7 as it appears on the Display License Programs screen. It will probably be 6 or 7.
Step 3: Install the Licensed Program onto your IBM i system.
RSTLICPGM LICPGM(2COZIQy) DEV(*SAVF) SAVF(QGPL/IQUERY)
Again, where y is the version you are installing. This may be different from the version you deleted. Currently it is 7, as in 2COZIQ7.
After you Restore the SQL iQuery License Program, you are prompted to select the JOBQ where the post-install build routine is submitted. If you blank out the job queue name, the post-install routine is not run and you may have difficulties using some SQL iQuery features.
Additionally, the EMAIL command used to send SQL iQuery output results as EMAIL attachments is specified on the final install screen. Select the one you'd like to use, then press Enter.
After installation for non-licensed users, 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-IQ7