Send email with SQL [email protected] (Simon Hutchinson)

​[[{“value”:”We have been able to send email from our IBM i partitions for several releases, using IBM commands and various third party tools. I use the Send SMTP Email command, SNDSMTPEMM, that comes within the IBM i operating system. Within the latest round of Technology Refreshes, IBM i 7.5 TR3 and 7.4 TR9, comes another way, with SQL.
A new scalar function was added to the SYSTOOLS library called SEND_EMAIL. It has four parameters:

TO_EMAIL:  Recipients email address. Mandatory
SUBJECT:  Email’s subject line. Mandatory
BODY:  Email’s body. Mandatory
ATTACHMENT: IFS path name of the file to be sent as an attachment. Optional, if omitted no attachment is sent

For example:
Read more »”}]] Read More 

Future-Proof Your Applications: Strategies for Modernizing with LANSA LANSA Editors

​[[{“value”:”Application modernization is crucial for organizations to stay resilient, responsive, and relevant on an enterprise scale. Some applications are faster and better than the 5250 applications that have been used for decades, so using outdated applications can lead to problems at work. LANSA’s modernization tools can help companies leverage state-of-the-art technologies to their benefit to
The post Future-Proof Your Applications: Strategies for Modernizing with LANSA appeared first on .”}]] Read More 

Cybercriminals Targeting American Water Infrastructure, Feds Say Alex Woodie

​[[{“value”:”Overseas cybercriminal groups are ramping up their attacks on American infrastructure, including drinking water and wastewater systems, the White House Government warned last week. Considering that many local water districts rely on the IBM i server, this should serve as a wakeup call for them to bolster security before it’s too late.
In a letter addressed to the governors of all 50 states, EPA Administrator Michael Regan and Jake Sullivan, assistant to the president for National Security Affairs, warned that government security professionals have detected attacks on water systems coming from China and Iran.
One of the attack vectors was …
The post Cybercriminals Targeting American Water Infrastructure, Feds Say appeared first on IT Jungle.”}]] Read More 

Shield Adds HMC, Security PTFs to Nagios Monitoring Solution Alex Woodie

​[[{“value”:”If you’d like to know what’s going on with your Hardware Management Console (HMC), you can do so through the updated Nagios offering from Shield Advanced Solutions. Version 2.1 of the company’s bundled AAG and NG4i offering also will automatically notify you when IBM has submitted security PTFs for the operating system or licensed products, and even download them for you.
After initially trying to use IBM’s open source Nagios software to monitor their customers’ high availability software environments, the folks at Shield Advanced Solutions took it upon themselves to develop their own Nagios distribution for the IBM i server, …
The post Shield Adds HMC, Security PTFs to Nagios Monitoring Solution appeared first on IT Jungle.”}]] Read More 

What’s Up with Open Source on IBM i? Alex Woodie

​[[{“value”:”Open source software has become a steadfast component of the IBM i stack. But what open source software are IBM i shops using today? Results from Fortra’s recent IBM i Marketplace Survey provide answers.
It may seem odd now, but open source hasn’t always been a staple of the IBM i server’s software diet. Until PHP arrived on the platform two decades ago, proprietary software was the only option for IBM i shops.
But today, IBM i shops have hundreds of open source products to choose from. Thanks to the IBM i server’s openness, just about any product that can …
The post What’s Up with Open Source on IBM i? appeared first on IT Jungle.”}]] Read More 

Verified by MonsterInsights