• Guru: Regular Expressions, Part 1

  July 25, 2022 Mike Larsen

  In the first part of this series, I will show how to replace characters in a string using SQL and regular expressions. I know I can replace characters using RPG or SQL, and they work great, but there are some cases where I find using regular expressions is a bit easier.

  For the examples I’ll show, I’m using the REGEXP_REPLACE function. REGEXP_REPLACE allows me to search for a particular value within a string and replace it with another value.

  In the first example (Figure 1), I want to search a string that has both letters and digits and I want …

  Read more

• What Happens To IBM i In A “Zero Datacenter, Zero Mainframe” FedEx?

  July 18, 2022 Timothy Prickett Morgan

  Federal Express, the pioneer in overnight document delivery for business founded in Little Rock, Arkansas, in 1971 by Frederick Smith, did not start out in the ground shipping business. But it did start its datacenter operations on IBM mainframes, as any company needing complex and intense computing would at the time, and it chose Memphis, Tennessee, in the heart of America, as its headquarters and base of operations in 1973 when the company moved from a PhD thesis at Yale University to a true business.

  In 1983, FedEx made history by being the first company in the United States to …

  Read more

• Guru: IBM i Experience Sharing, Case 5 – Using IBM i PDI Charts To Answer Performance Questions

  July 18, 2022 Satid Singkorapoom

  During my long career as an IBM i performance specialist, it was natural for people to ask me performance-related questions of various kinds. But in many cases, it seemed to me that the customer could not understand my answers, and I could not provide supporting evidence due to the lack of a performance reporting tool that could produce easy-to-understand explanatory information. The situation changed for the better with the availability of IBM i Performance Data Investigator (PDI) tool as of release 6.1. I would say that the PDI tool provides charts of information that resemble those used by business people …

  Read more

• Exploring Security Applications for IBM i OLAP

  July 13, 2022 Alex Woodie

  The IBM i platform is typically thought of as a transactional server, and it does that job very well. But it also has solid analytical capabilities, thanks in large part to new OLAP features added many years ago with IBM i 7.3. Now the platform’s database guru, Scott Forstie, is looking for ways to promote greater use of these OLAP capabilities, and security is emerging as a top application.

  Sometimes it takes a while to figure out what a good thing you have. This appears to be the case with IBM i 7.3, which launched way back in 2016 and …

  Read more

• Multiple Security Vulnerabilities Patched on IBM i

  June 22, 2022 Alex Woodie

  In recent weeks, IBM has disclosed a handful of vulnerabilities in its IBM i operating system and related IBM i products, including Db2 Mirror, WebSphere, Navigator for i, the Java development and runtime tools, and OmniFind Text Search Server. IBM has shipped PTFs for the security problems, which range in severity from medium to high.

  IBM warned of security holes in the HTTP Server (the one powered by Apache) in a June 13 security bulletin. The flaws, identified as CVE-2022-22720 and CVE-2022-22721, carry the risk of a HTTP request smuggling that could poison the Web cache, bypass firewalls, and …

  Read more

• Profound Logic Shows Off No-Code API for Salesforce

  June 15, 2022 Alex Woodie

  IBM i shops that are looking for a way to integrate their Db2 for i data with Salesforce applications may be interested in a new REST API unveiled by Profound Logic last month. What’s more, the vendor says the solution works without writing a single line of code.

  Profound API, which the company launched just over a year ago, is a Node.js-based offering that runs directly in a Web browser. The product contains several editors and a runtime that enables users to define their APIs, test them, manage them as they’re pushed into production, and monitor performance over time. …

  Read more

• Let’s Celebrate The Diamond Jubilee Of COMMON Europe

  June 13, 2022 Timothy Prickett Morgan

  Europe is a collection of countries that, over centuries of commerce, cultural exchange, and war have learned to come together and create a community of common interest. And so it is not a surprise at all that COMMON Europe, which is celebrating its 60^th year – it’s Diamond Jubilee – and that is something that very few organizations in the world ever attain.

  And so, as the COMMON Europe Congress gets underway today in Alicante, Spain, we wanted to offer our congratulations and celebrate that longevity and continuity. (If you have a hankering to travel this week, you can …

  Read more

• IBM i PTF Guide, Volume 24, Number 22

  June 1, 2022 Doug Bidwell

  Well, there is a lot of stuff going on with IBM i PTFs this week, with cumulative patch rollups, or Cumes as we call them, Technology Refreshes, and other goodies. Specifically, IBM i 7.3 and IBM i 7.2 have Cume rollups, as well as their respective TR6 and TR12 updates of new functionality.

  There are also two new security vulnerabilities. First, there is Security Bulletin: IBM Navigator for i is vulnerable to an SQL injection (CVE-2022-22495), which you can read about at this link. The patches for this vulnerability are as follows:

  IBM i Release	HTTP Server for i 

  …

  Read more

• ERP Transitions Loom for SAP on IBM i Customers

  May 23, 2022 Alex Woodie

  Unless SAP changes its plans, the company will end mainstream support for its business software running on IBM i in five years, with an option for extended maintenance through 2030. The looming end of support for the decades-long partnership between the IBM i organization and the German software giant puts about 1,500 joint customers in the tough spot of deciding how to transition away from their current ERP platform. And one they have probably invested a lot of time, money, and effort into.

  SAP’s preferred destination for all of its ECC (ERP Central Component) and Business Suite customers – …

  Read more

• What’s New in IBM i Services and Networking

  May 18, 2022 Alex Woodie

  As expected, IBM delivered a slew of new IBM i services with the delivery of IBM i 7.5 last week, giving IBM i professionals handle new methods for working with various components of the platform. The new releases of the operating system also brings a number of enhancements in the networking stack, which are notable for several reasons.

  The past several new releases and Technology Refreshes (TRs) have brought new IBM i services, which are SQL-based alternatives to traditional ways of accessing things on the platform like IBM i objects, system information, and other components. At this point, IBM has …

  Read more

Previous Articles Next Articles