SQL iQuery for IBM i

Added an Excel Date Format to the XLSOPT parameter of the RUNiQRY command. This parameter allows users to specify the Excel date format for dates in their output XLS (SpreadSheetML) files using genuine Excel Date Formatting codes.
Corrected an issue where the EMAIL NOTE and LONGMSG parameters of the IBM SNDSMTPEMM and SNDDST would include several UTF-16 characters if no message BODY (NOTE or LONGMSG respectively) was specified. Now, iQuery inserts the required default value of *NONE when no message body is specified when sending query resultSets to an email address.
NOTE: We no longer update the IBM i V7R2 version of SQL iQuery. If you need that to include any updates listed above this line, please reach-out for customized versions (for a small fee).
latest update removes several low-level messages that were written to the joblog for trace/debug purposes and are no longer needed. In addition an issue with the FOR EACH command in SQL iQuery Script when it is the only LOOP/Control statement in a script is corrected.
Be sure to use the save file for your IBM i release level.
If you are on V7R3 or later, use IQUERY.SAVF
If you are on V7R2, use IQUERY72.SAVF

Each refresh of SQL iQuery is to provide better performance or correct known/reported issues.
The feature code base is now at code-freeze so there should be few refreshes moving forward.

SQL iQuery for IBM i

This release contains fixes an issue with our free SENDMAIL option that emails SQL iQuery results.
The structures in the IQRYEMAIL program were not being initialized. This build corrects that issue.
No other changes have been made.

The full SQL iQuery license-free program for IBM i. These ZIP files contain a SAVE FILE (SAVF) of the licensed program that may be uploaded to your IBM i system and then RSTLICPGM may be run using that SAVF.
This version of SQL iQuery is a no-charge licensed program, requires no license key, and works with IBM i V7R3 and later.
There is also a V7R2 build available with identical functionality for those still running IBM i V7R2.
Note that IBM i V7R3, R4, R5 and later Users should use the IQUERY.SAVF to install the product as the V7R2 version is not optimized as well for later releases.
Service and support are available for a small fee if needed. Support fees are not required to install and use this product.

SQL iQuery for IBM i

This release contains the full SQL iQuery license-free program for IBM i. These ZIP files contain a SAVE FILE (SAVF) of the licensed program that may be uploaded to your IBM i system and then RSTLICPGM may be run using that SAVF.
This version of SQL iQuery is a no-charge licensed program, requires no license key, and works with IBM i V7R3 and later.
There is also a V7R2 build available with identical functionality for those still running IBM i V7R2.
Note that IBM i V7R3, R4, R5 and later Users should use the IQUERY.SAVF to install the product as the V7R2 version is not optimized as well for later releases.
Service and support are available for a small fee if needed. Support fees are not required to install and use this product.