Today is the day that IBM has announced the Fall 2023 Technology Refreshes for the currently supported releases of IBM i, 7.5 TR3 and 7.4 TR9.
All the information about the TRs can be found on IBM website on the following on the following pages in IBM's websites:
- IBM i 7.5 TR3
- IBM i 7.4 TR9
The planned availability date for the TRs's PTFs in November 17, 2023, with the exception of those for the PowerHA SystemMirror for i which will be made available on December 15, 2023.
It appears that the same additions and enhancements have been added to both TRs. There are 17 additions and 19 enhancements to Db2 for i, three to RPG, and a whole lot more added to Navigator for i.
The things that caught my eye are (these links are to the IBM i 7.5 documentation):
- DB2 for i
- New scalar function ENCRYPT_AES256 allows me to encrypt a string using the AES algorithm with a 256 bit key
- New scalar function GENERATE_SPREADSHEET creates a file in the IFS based on the results of a SQL Query
- New scalar function IFS_RENAME that allows me to rename files and directories in the IFS
- New scalar function REPLY_INQUIRY_MESSAGES allows me to answer on or more message in QSYSOPPR message queue
- New scalar function SEND_EMAIL allows me to send an email
- New table function SQLCODE_INFO returns the SQL message from the QSQLMSG message file associated with the SQLCODE value
The above links are all to the IBM Support web site, some of the links on those pages do not resolve to the appropriate pages in the IBM Documentation site.
New additions to RPG include:
- %LEFT and %RIGHT built in functions to retrieve a certain number of positions from a variable
- Sets of constants will be known a enumeration
The Support Wiki pages even show the changes that were made to the latest version of ACS, 1.1.9.3.
Today is also the withdrawal of IBM Db2 Web Query. You can see the announcement about that here.
Very curious about the spreadsheet function. I got a “Not Found" when I dig around about it on IBMs site.
ReplyDeleteThe pages in the IBM Documentation web site were missing at the time of the announcement. As the day has progressed the relevant IBM Documentation pages have been added.
Delete