Fortra, formerly known as HelpSystems, has opened their annual IBM i marketplace survey.
This is the eleventh-year they have had the survey. It provides a useful insight to what the IBM i community is up to, and what are their concerns.
The survey opened last Friday, and will close on October 31. The results will be published in January 2025.
I encourage you to take part. I did so on Friday.
You can get to the survey using the link here.
As part of the latest Technology Refreshes a number of improvements have been added to the SEND_EMAIL scalar function.
What are these:
All of which are useful additions to SEND_EMAIL.
Let me jump right to giving an example of using more than one email address and the new cc and bbc email parameters:
IBM published a document last month, August 2024, called "IBM i: Integrate and innovate", with the subtitle "An executive guide to the strategy and roadmap for the IBM I integrated operating environment for IBM Power servers". I think it is great that IBM publishes documents like this. I read them all, and share them with you too.
It is a 31 page document that IMHO you should share with your colleagues, managers, and executives. I will be doing so myself today.
The document can be reached on the IBM website by clicking on the link here.
I struggled with the title of this post to make it something that explains the content, without it being too long. I am not limited for length in the body of this post so I can explain in more detail my scenario: I want to have columns that are listed in my results for a Select statement that are not in the GROUP BY clause.
This is something that has been made easier with a new Scalar function added in the latest round of Technology Refreshes. First let me give you examples of my scenario.
What I am going to do is to take use my PERSON DDL Table and make a count of the places of birth of the people. As these are people from the British Isles, I will also include the columns for the county and the country (England, Ireland, Northern Ireland, Scotland, or Wales) from a second Table, TOWN.
This month I have two events I am involved with.
The September meeting of the Central Texas IBM i User Group, CTXiUG, is on Tuesday September 10 starting at 6:30 PM (CT). The guest speaker is Jasmine Kaczmarek who will be sharing "IBM i Manager's Survival Guide: Ransomware, Retirement Cliffs and more". Which is something I think we all need to be aware of, not just those of us who are managers.
You can register at the CTXiUG website here.
On Monday September 23 and Tuesday September 24 I will be attending and presenting at Common Sweden's annual conference. You can learn more about, and register, for the conference here.
I hope to see you there. And if you are attending and you see me, please introduce yourself and say "Hallå".