• VS Code Is The Full Stack IDE For IBM i

  March 15, 2023 Jeff Tickner

  Back in January, we talked a bit about the rise of the VS Code integrated development environment that was open sourced by Microsoft back in 2015 and that has been increasingly adopted by developers on all kinds of platforms, not just Windows Server. This week, we want to talk about the new features we are exposing in VS Code for users of the application development tooling available from ARCAD Software.

  First of all, we have brought the cross reference information in our ARCAD Observer tool into VS Code in a way that developers can access the object-level and field-level …

  Read more

• Db2 Web Query: Way More Than Just A Query Tool

  February 27, 2023 Alex Woodie

  You might be forgiven for thinking that Db2 Web Query is just a way to run your SQL queries on IBM i from a browser. After all, “Web” and “query” are right there in the name, aren’t they? But the product’s name belies the true nature of this multi-threat analytics application, which can do a whole lot more for IBM i shops than just run queries.

  IBM’s Doug Mack tackled this reality-assumption gap during a recent webinar on Db2 Web Query, which received a bunch of new capabilities with the recent version 2.4.0 upgrade. Mack, a longtime IBMer whose …

  Read more

• IBM i PTF Guide, Volume 25, Number 8

  February 27, 2023 Doug Bidwell

  We are playing catch up a bit here at the IBM i PTF Guide, and apologies for that but it goes that way sometime. There are a bunch of security vulnerabilities that you need to be aware of, including one that covers systems software not from IBM, as we usually track, but file transfer software from Forta (formerly known as HelpSystems). We are going to be keeping a closer eye on third party software security bulletins going forward.

  So first, we have CVE-2023-0669, which explains that GoAnywhere MFT from Fortra (formerly HelpSystems) suffers from a pre-authentication command injection …

  Read more

• RPG Use “Skyrocketed” Says IBM i Marketplace Report

  February 20, 2023 Alex Woodie

  RPG has always been the number one development language on IBM i, the platform with which it is most closely linked. But as open source languages like PHP and Java spread on IBM i, some speculated that RPG’s popularity would begin to slip. That hasn’t happened, according to Fortra’s most recent IBM i Marketplace Survey Results report. In fact, usage of RPG has “skyrocketed,” it says.

  From 2015 to 2020, the percentage of Fortra (formerly HelpSystems) Marketplace Survey-takers who chose RPG as one of their development languages stayed steady, hovering around the 84 percent to 89 percent level. Structured Query …

  Read more

• Infoview Systems Launches Lightweight CDC for IBM i

  February 13, 2023 Alex Woodie

  IBM i shops that have a need to extract the latest transactions hitting their Db2 for i database for downstream CRM, analytics, or fraud detection use cases may want to check out the new change data capture (CDC) offering unveiled recently by Infoview Systems. When coupled with a streaming data platform like Apache Kafka, CDC opens up new possibilities.

  Infoview Systems is a longtime IBM i product and services firm based in Michigan with a global customer base. The company has been active in the data and application integration space for years, first with the sale and implementation of message …

  Read more

• White Hats Completely Dismantle Menu-Based Security

  February 6, 2023 Alex Woodie

  Think menu-based security can prevent cybercriminals from accessing the most important parts of your IBM i system? Think again, as the white hat hacking group Silent Signal recently demonstrated in a real-world penetration test of a bank’s IBM i system through a seemingly restricted green-screen interface.

  Life was demonstrably simpler for midrange administrators before the Internet took off. Before we had all these different protocols providing access to applications and data – ODBC, FTP, SQL, Remote Command, etc. – an administrator could feel somewhat confident that users weren’t accessing things they shouldn’t by simply configuring their menus in a restrictive …

  Read more

• N2i Gains Traction Among IBM i Newbies

  January 25, 2023 Alex Woodie

  The YiPS made a big push to inject youth into the IBM i community over a decade ago. But when the youthful vigor ran low, members of the community regrouped, re-energized, and rebranded into a new group called New to IBM i (N2i). And judging from N2i’s recent success, the group has hit on something.

  N2i has its roots in the YiPS, according to Marina Schwenk, who was a YiPS member back in the day and now is active in COMMON and the WMCPA. But there’s a crucial difference between N2i and YIPS, she says.

  “The group that we’re …

  Read more

• Realizing The Promise Of Cross Platform Development With VS Code

  January 25, 2023 Jeff Tickner

  An integrated development environment is like a tractor or a truck, or indeed any other kind of tool. There are farmers who want a tractor from John Deere or Ford or Massey-Ferguson, contractors who want a Ford or Dodge or GMC truck, and carpenters and electricians who use Dewalt or Milwaukee Electric or Makita cordless tools.

  No matter the choice of tools, ultimately these blue collar workers are going to farm and build things, and the choice of tool should not interfere with that effort. White collar – or far more likely no collar T shirt – programmers are no …

  Read more

• 2023 IBM i Predictions, Part 3

  January 25, 2023 Alex Woodie

  Security. Cloud. AI. The IBM i installed base moves with the general IT tide, which makes these hot topics for all. But what about specific IBM i things, like the availability of IBM i jobs and the difficulty in finding a good RPG developer? These are topics we are tackling in our third – and final – round of 2023 predictions.

  Bob Langieri, the IBM i recruiter who owns Excel Technical Services, has his pulse on the IBM i job situation, particularly in his Southern California region. 2023 looks to be a mixed bag, job-wise, he says.

  “In the …

  Read more

• Multiple Vulnerabilities Pop Up In Navigator For i

  January 23, 2023 Timothy Prickett Morgan

  Why do we network computers again? Remind me.

  A new security bulletin was released for the Navigator for i system management interface for the IBM i platform on January 18, which rolls up four different vulnerabilities for Navigator for i that leave it open to log file access, to obtaining file attributes, and to SQL Injection attacks due to multiple other vulnerabilities.

  You can read about this security bulletin at this link. The most severe of the issues is the SQL injection attack, which has a CVSS Base score of 6.3 out of 10. According to the bulletin: “IBM …

  Read more

Previous Articles Next Articles