• Guru: SQL and Expanding Subfiles

  October 26, 2020 Ted Holt

  I’ve heard it said on more than one occasion that SQL does not work as well as record-level access (RLA) when loading subfiles. I understand why people feel that way. They’re usually thinking about repositioning to a key value, and there is no SETLL (Set Lower Limit) op code in an SQL cursor.

  Yet I think SQL is better, and today I’d like to share one case that I think presents a good illustration. I had in mind the expanding subfile. There’s a parallel between the two. Consider:

  • Every time you clear the subfile, you open a new cursor.
  • Every

  …

  Read more

• Does IBM i Need Its Own Zowe?

  September 30, 2020 Alex Woodie

  Getting open source software onto platforms like IBM i and System z is a big focus of IBM, its big iron customers, and the ecosystem of tool and service providers that tread these waters. In 2018, IBM, CA Technologies, and Rocket Software collaborated to create the Zowe framework as a part of the Linux Foundation’s Open Mainframe Project, with the goal to extend System z-based services into the greater open source IT landscape. Is it time for a similar effort on IBM i?

  When Zowe launched two years ago, the Open Mainframe Project (OMP) boasted that Zowe would “serve as …

  Read more

• ERP Deployments Shift Cloudward, Even On IBM i

  July 20, 2020 Alex Woodie

  Applications of all sorts are moving to the cloud, including the critical ERP systems that businesses rely on to automate processes. That’s been the trend for some time in the industry as a whole, but it’s also having an impact on the IBM i community, which is becoming cloudier by the month.

  While on-prem deployments of IBM i still dominate, the cloud portion is growing. Nearly one-quarter of IBM i shops have IBM i resources running in the cloud, according to HelpSystems’ 2020 IBM i Marketplace Study, including 6 percent who are cloud-only and 17 percent who run …

  Read more

• Raz-Lee Launches Web Interface for iSecurity Suite

  May 20, 2020 Alex Woodie

  Green screen interfaces were just fine in the old days of the AS/400. But today, many IBM i administrators would prefer a little more color with their screens. For IBM i shops that use software from Raz-Lee Security to police their system, they now have the option of using a Web-based graphical user interface (GUI) to interact with the company’s entire suite of tools.

  Raz-Lee has included GUIs in its offerings for many years. In the 2000s, it developed a Java-based interface for certain components of its iSecurity Suite. More recently, it developed an Eclipse-based product called the iSecurity GUI …

  Read more

• IBM i 7.3 Encryption Bolstered With TR8

  April 15, 2020 Alex Woodie

  Customers running IBM i 7.3 got some good news on the security front when IBM announced that the operating system would get support for the latest Transport Layer Security (TLS) protocol, version 1.3. And that’s not the only security-related enhancement this group of users received with the new Technology Refreshes.

  Last year, IBM gave IBM i shops the ability to use TLS 1.3, which is strongest publicly available encryption protocol used on the Internet today. TLS 1.3 debuted in the summer of 2018 and has since been adopted by nearly a quarter of sites on the Web, according to surveys. …

  Read more

• Thoroughly Modern: Taking The Pulse Of IBM i Developers

  January 22, 2020 Timothy Prickett Morgan

  (Sponsored Content) It takes someone who has experience in application development to create and sell tools that help make a developer’s job easier. We think about the tool creators, but when it comes to getting people to adopt a new technology, the technical sales team at any software company is the bridge that connects developers of tools to the developer of applications who can be helped by those tools. In this edition of Thoroughly Modern, we are talking with Stephen Flaherty, a technical engineer at Fresche Solutions, about what IBM i developers are thinking about and doing …

  Read more

• Nagios Solidifies Role in IBM i Monitoring

  December 4, 2019 Alex Woodie

  IBM i shops that are looking for monitoring solutions would do well to add Nagios to their short list. The open source software has been embraced by IBM i shops, and thanks to a new SQL connector added by IBM with the latest technology refreshes and plans for monitoring the HMC, Nagios connectivity to IBM i is on the upswing.

  Nagios Core is a free, open source software project that’s been adopted by thousands of customers around the world to monitor servers, storage, software, services, networking gear, and anything else that can be connected to the network. The software is …

  Read more

• Remain Hooks Change Management System Into GitLab

  November 13, 2019 Alex Woodie

  IBM i shops that manage their code using Remain Software’s change management software just gained a slew of new ways to hook their system into GitLab, an independent Git-based provider of DevOps solutions. The new software, TD/OMS V12 Milestone 1, also brings better integration with unit testing and cross referencing, while a new release of Remain’s Gravity bolsters management of cross-platform development projects.

  With a steady cadence of quarterly updates and one big release per year, Remain Software is endearing itself to IBM i developers who like predictability and perseverance. IBM i technology may not be moving incredibly fast at …

  Read more

• Revenge Of The Zombie Green Screen

  October 30, 2019 Alex Woodie

  Don’t look now, but command line interfaces – which were supposed to have been killed off years ago at the hands of superior graphical user interfaces (GUIs) – are making a comeback in the general IT scene. And the command line love appears to be spilling over into the IBM i.

  Command line interfaces, or CLIs, never completely disappeared from the scene. Even Windows 10 users can summon the dark magic of the DOS prompt with a few tactical clicks of the keyboard, mouse, or (God forbid) touchscreen. But like crazy uncles and credit card debt, the CLI has largely …

  Read more

• Guru: Move Objects with Access Client Solutions

  October 14, 2019 Dawn May

  Sending objects from one IBM i partition to another is a common task. Access Client Solutions’ IFS task makes it simple to copy or send objects. The IFS task was introduced in ACS in July 2016, so this is not a new development, but it may not be widely known.

  Perhaps you need to send a save file to another IBM i partition. There are several ways to do this. FTP and Secure FTP are often used, but using FTP to transfer IBM i objects involves all sorts of complications. The IBM i Knowledge Center dedicates an entire section on …

  Read more

Previous Articles