• Guru: Alternate SQL Row-Selection Criteria Revisited Revisited

  September 27, 2021 Ted Holt

  I am not a “do as I say and not as I do” kind of person. After I wrote the article Guru: Alternate SQL Row-Selection Criteria Revisited, I got serious about using dynamic SQL in my RPG programs instead of enabling and disabling logical expressions in the WHERE clause. I’m reliving the days when OPNQRYF was my best friend, trying to make apostrophes play nice with string concatenation.

  Overall, I’m happy with the change. When I have converted the switch-laden version to dynamic SQL, I have seen a noticeable performance improvement in some cases, and at least a slight …

  Read more

• IBM Adds Public Cloud Targets For IBM i Cloud Backup

  September 27, 2021 Alex Woodie

  The cloud has become a popular place for organizations to store backups. And with the recent Technology Refreshes (TRs) for IBM i, the number of targets for the Cloud Storage Solutions for i has increased significantly.

  IBM debuted Cloud Storage Solutions for i back in 2016 as a connector that allowed Backup, Recovery, and Media Services (BRMS) to push IBM i backups over the Amazon S3 protocol to the Cleversafe object storage system running in SoftLayer, the public cloud platform that would become IBM Cloud in 2018 (IBM would subsequently rename Cleversafe as IBM Cloud Object Storage).

  IBM has augmented …

  Read more

• The Big Iron Customers That The Power E1080 Is Aimed At

  September 27, 2021 Timothy Prickett Morgan

  One of the central tenets of our philosophy here at The Four Hundred is: Anything that makes Power Systems stronger helps IBM i last longer.

  For as long as we have been watching the AS/400 and IBM i market, big iron has driven a lot of revenue for machines based on IBM’s proprietary CISC processors and then PowerPC and Power RISC processors. And the big iron machines drove even more of the profits from these products. Big iron is, therefore, important. But just how much money are we talking about?

  A lot more than you probably think, as it …

  Read more

• COMMON Cancels In-Person POWERUp Again, Takes Conference Virtual

  September 22, 2021 Alex Woodie

  COMMON announced last week that it has cancelled the in-person portion of the POWERUp 2021 conference that was scheduled to take place in Virginia Beach due to the Delta variant that is causing coronavirus infections to surge. That’s the bad news. The good news is that the show will go on as a virtual conference October 4-7.

  This was the third time in two years that COMMON has been forced to cancel or delay its POWERUp conference. Like Lucy pulling the football away from Charlie Brown just as he’s about to kick it, SARS2 just won’t let COMMON actually hold …

  Read more

• Transferring Low Code Benefits Into The IBM i

  September 22, 2021 Eugene King

  As with fashion, there are trends in the IT industry and history tends to repeat itself in several exciting ways.  Development languages come into fashion, run their course, and then become obsolete. Then, they may be revamped with the addition of new criteria and frameworks. IBM i development also follows these same trends.

  The low-code movement is not new but another iteration on traditional programming. Let’s do a brief history review.

  At first, computer programming involved specific machine code associated with a particular processor architecture.  Eventually, the language was slightly abstracted to facilitate second-generation assembler code, which was partially portable …

  Read more

• IBM Improves Run SQL Scripts with ACS Update

  September 22, 2021 Alex Woodie

  In recent years, Access Client Solutions (ACS) has become an indispensable utility for a range of tasks involving the IBM i. A good reason for that success is the adoption of Run SQL Scripts, which has been enhanced with the latest Technology Refresh for IBM i 7.3 and 7.4.

  ACS is a Java-based product that IBM first unveiled in 2012 and that has replaced other versions of Client Access, including the dedicated Windows utility. No matter what type of computer or device you’re using to work with the IBM i server, be it Windows, Linux, or Mac, you can access …

  Read more

• Four Hundred Monitor, September 22

  September 22, 2021 Jenny Thomas

  I was having a conversation with our fearless leader, IT Jungle president and editor-in-chief Tim Prickett Morgan, recently and we were lamenting the fact that it seems like fewer people want to talk on the phone. The exchange of phone numbers in email signature tags isn’t standard operating procedure for everyone these days, as people seem to prefer electronic communication that they can control when it is convenient rather than dealing with the interruption of a phone call. Having come up in the days where everything was done by phone (and fax, for those of us who remember), the adjustment …

  Read more

• IBM i PTF Guide, Volume 23, Number 38

  September 22, 2021 Doug Bidwell

  Another week, another security vulnerability in open source code. Check out Security Bulletin: ISC DHCP for IBM i is affected by CVE-2021-25217, which you can view at this link. Here are the patches by release that deal with the issue:

  • IBM i 7.4: SI76506
  • IBM i 7.3: SI76507
  • IBM i 7.2: SI76509
  • IBM i 7.1: SI76508

  Another reminder to everyone to participate in POWERUp 2021, which runs virtually from October 4 through 7. Visit the COMMON user group web site to find out the particulars. And we will see you there – virtually, that is!

  Let’s get started this …

  Read more

• IBM i Open Source Gets Better With Fall 2021 TRs

  September 20, 2021 Alex Woodie

  The open source community has become a big source of new software for the IBM i platform in recent years, if not the biggest contributor. To that end, the recent Technology Refreshes (TRs) for IBM i 7.3 and 7.4 bring a dozen or so new or updated packages to the platform.

  One of the most exciting additions to IBM i’s open source repertoire is tn5250, a bare-bones terminal emulator for accessing IBM i system and application screens. Distributed via Source Forge, tn5250 is a Windows program that enables users to access green screens from the Secure Shell (SSH) terminal. …

  Read more

• Value Stream Management: Bringing Lean Manufacturing Techniques To IBM i Development

  September 20, 2021 Andrew Ireland

  When resources are tight, it is important to optimize their usage and maximize the business value they deliver. This is the very foundation of what is called lean manufacturing or just-in-time manufacturing, which more than a few IBM i shops know a thing or two about because this platform has been used for decades by process and discrete manufacturers to automate their businesses.

  The move toward DevOps has allowed software engineers to adopt many of the best practices developed by manufacturing over the last 100 years. These include automating the flow of code, a repository of standard components and a …

  Read more

Previous Articles Next Articles