Pages

Thursday, October 13, 2022

Fall 2022 Technology Refreshes announced

The one day on my vacation I was beyond the reach of the internet, IBM announced their latest Technology Refreshes for IBM i 7.5 and 7.4 . As 7.3 is nearing the end of support there will be no more TR for it.

What caught my eye in these TRs?

As usual the Db2 for i has produced many new things for us to use. The first thing that caught my eye is the new REMOTE_TABLE, will I be able to access table functions on remote partitions using the three-part name? I cannot wait to try this.

A scalar function to return the first day of the month. This compliments the LAST_DAY scalar function.

The new SQL Error Logging Facility, SELF, looks like a great new feature to analyze my SQL statements (see what went wrong).

A View and Table function to list all of the attached hard ware resources.

Many more Table functions to allow me to easily extract different types of the data from the system audit journal.

New to RPG we have a keyword when declaring your procedure prototypes that will convert a parameter to a string.

Built in function %CONCAT to allow the concatenation of various strings or variables into one result. And %CONCATARRAY to concatenate the contents of an array into one string.

The %CHARCOUNT will return the number of characters in a string, and not be fooled by the DBCS characters which will be counted a two. And the *NATURAL keyword that can be used in other BiF, like %SUBST, to ignore the double byte of DBCS.

I am really excited about ZLIB compression on saves, and there are further enhancements to it. Alas, none of the partitions I currently have access to is a Power10, therefore, I am unable to use it.

The is much more, as I said this is what just caught my eye.

All of this new cool stuff will be available December 2, 2022, except for the features for PowerHA System Mirror which comes later on December 16.

If you want to learn more, and see what catches your eyes check out:

Don't forget that when you download the TR PTFs you will also need to download the Database and RPG PTFs separately.

No comments:

Post a Comment

To prevent "comment spam" all comments are moderated.
Learn about this website's comments policy here.

Some people have reported that they cannot post a comment using certain computers and browsers. If this is you feel free to use the Contact Form to send me the comment and I will post it for you, please include the title of the post so I know which one to post the comment to.