• The (More) Modern RPG Language

  December 16, 2019 Bob Cozzi

  Back in 1988, I wrote what became the book on RPG III. Then in 1996, I published the RPG IV version and updated it again circa 2000. But in the years that followed, RPG IV became mostly stale; a tweak here and there, but nothing too spectacular.

  In recent years, a wave of RPG IV enhances has been revealed, most notably free-format was completed and helped propel RPG IV, once again into a truly modern language. Although the measure of “modern” for RPG IV seems to lean toward how much free-format syntax is supported; which is ironic considering COBOL and …

  Read more

• Guru: More End Of Year Feedback

  December 9, 2019 Ted Holt

  You are busy. The people you serve need you to do more than one human being can do. You don’t have time to look for comments or updates to the articles we run in this august publication or any other. For this reason, I was pleased to publish some of your feedback in last week’s issue. This week I am pleased to share a bit more.

  In response to Guru: MERGE, Chicken, and Eggs, John asked a good question and made a good point:

  How is using this merge technique under commitment control any different than just doing the …

  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

• How Infor’s Coleman Strategy Is Evolving, and How IBM i Fits In

  November 20, 2019 Alex Woodie

  It’s been more than two years since Infor unveiled Coleman, the company’s AI platform which became generally available earlier this year. It’s not on the roadmap for IBM i just yet, according to Infor. That may not sound ideal for Infor’s IBM i customers, but it’s not necessarily a bad thing.

  Coleman was unveiled by ERP software giant Infor in 2017 primarily as a digital assistant, which is a fancy way of saying a chatbot. Just as Siri and Alexa can answer questions about the weather or sports, Coleman could answer basic questions about the business, and even handle some …

  Read more

• Entry Server Bang For The Buck, IBM i Versus Red Hat Linux

  November 11, 2019 Timothy Prickett Morgan

  In last week’s issue, we did a competitive analysis of the entry, single-socket Power S914 machines running IBM i against Dell PowerEdge servers using various Intel Xeon processors as well as an AMD Epyc chip running a Windows Server and SQL Server stack from Microsoft. This week, and particularly in the wake of IBM’s recent acquisition of Red Hat, we are looking at how entry IBM i platforms rate in terms of cost and performance against X86 machines running a Linux stack and an appropriate open source relational database that has enterprise support.

  Just as a recap from last week’s …

  Read more

• The All-Knowing, Benevolent Dictator Of Code

  November 6, 2019 Sebastien Julliand

  Not every software project can have an all-knowing benevolent dictator looking through every line of code, and even all projects could have such a person to oversee the quality of the code, there is no reason to not automate as much of this very important code review job as is possible.

  Luckily for IBM i shops, there is such a tool to help with code review, and in that sense, we suppose, you can install rather than hire that all-knowing benevolent dictator of application code. It’s called, appropriately enough, CodeChecker, and it has been available from ARCAD Software for quite …

  Read more

• IBM i TRs Bring Database Enhancements, Too

  October 30, 2019 Alex Woodie

  The heart of the IBM i server is its database, so it’s natural that we would see some enhancements to Db2 for i with delivery of IBM i 7.4 Technology Refresh 1 and 7.3 TR 7 next month. The new features may not be earth-shaking, but they deliver some useful functionality nonetheless.

  Let’s start with some foundational changes to the database itself, including the way that database engineers architect the tables that store information in the database. With 7.4 TR1, IBM i shops can now add a new child table to the database without having an exclusive lock on the …

  Read more

• Guru: Debugging Common Table Expressions

  October 21, 2019 Ted Holt

  I cannot say enough good things about common table expressions. Words like wonderful and marvelous don’t begin to describe them. However, CTEs do add a bit of complexity to an SQL query, and when the result set doesn’t contain the correct results, any common table expression can be the culprit. Fortunately, debugging queries with common table expressions is not difficult.

  To illustrate what I mean, let’s assume we have a query that retrieves shipment information for one day. It involves a few tables:

  • a one-row table containing a shipment date
  • a table of shipment header information
  • a customer master table

  …

  Read more

• IBM i 7.3 And 7.4 Get Their Autumn Tech Refreshes

  October 9, 2019 Timothy Prickett Morgan

  Big Blue is hosting its IBM Systems Technical University this week, and used the occasion to quietly launch the Technology Refreshes, or TRs as they are known, for IBM i releases 7.3 and 7.4. If you were running around the Venetian Hotel, you could probably stitch together the extent of the updates to the platform, and to be honest, we are still trying to get all of the details, which were not available as we went to press.

  We will tell you what we know now, and then circle back and drill down into the details as appropriate.

  First of …

  Read more

• Raz-Lee Asks ‘What If’ With Firewall

  October 9, 2019 Alex Woodie

  Security administrators who feel challenged to keep up with the volume and variety of log data emanating from the IBM i server may be interested in the new “What If” features that Raz-Lee Security recently added to Firewall, its exit-point management solution for IBM i.

  Firewall helps to guard network access points to IBM i servers, including TCP/IP, FTP, Telnet, DHCP, and other protocols. The software lets administrators set global and specific access rules for groups of IBM i servers and users, as well as controlling access to IBM i objects and providing the ability to set exceptions for specific …

  Read more

Previous Articles Next Articles