Month: September 2023

​Press Release: Immediate Release – September 2023 Toronto, Ontario – Shield Advanced Solutions Ltd is excited to announce the release Version 2.0 of their Nagios Monitoring plugin for IBM i – AAG!   Choose AAG Read More 

​Carol discusses the characteristics she’s observed over the years that are indications an organization isn’t taking IBM i security as seriously as it should.
Here are the characteristics I’ve observed over the years that indicate to me that an organization isn’t serious about attaining a secure IBM i. Read More 

​This piece of SQL was brought to my attention by a friend who works with Db2 for z/OS (mainframe). He said that at times he uses what I am going to explain to validate that the data he inserted into Table has the values he expected.
He refers to it as “Select final table”, which will be the name I am going to use for it. I did find this referred to in the IBM Documentation web site, there is a link to this page at the bottom of this post. The Db2 for z/OS version has more functionality than one for Db2 for i. This has me puzzled, why they are not the same?
With Db2 for i “Select final table” can only be used with a SQL Insert subselect. It returns the rows that were inserted into the table.
The Table, TESTTABLE, I will be using in these examples has two columns:
Read more » Read More 

​This document provides options to the user in the event that a STRFSFLASH process fails to complete successfully Read More 

​With data becoming a strategic asset for many organizations around the globe, more and more business owners are turning to BI solutions to extract valuable insights and make informed decisions. BI tools not only facilitate the consolidation and analysis of large datasets from multiple sources, but also enable users to identify potential revenue streams or
The post How LANSA BI brings real-time insights to IBM i applications appeared first on LANSA. Read More