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.