• iTech Solutions Keeps You In The Know With VERIFi

  February 22, 2021 Alex Woodie

  “An ounce of prevention is worth a pound of cure.” That time-tested bit of advice from Ben Franklin has many applications, including, it turns out, IBM i systems management. And through its new VERIFi offering, iTech Solutions is set to provide many ounces of prevention by keeping customers on top of what is happening with their IBM i servers.

  iTech Solutions’ VERIFi comes in three flavors. With VERIFi Weekly Status Reporting, the company remotely monitors key aspects of IBM i server health and summarize those findings in a PDF sent once a week for $295 per year. It offers …

  Read more

• Thoroughly Modern: What’s New With PHP On IBM i?

  December 7, 2020 Timothy Prickett Morgan

  (Sponsored Content) If you use PHP on IBM i, you’ve likely seen some recent announcements about some great changes coming to the open-source language. According to the latest blog post from Zend on PHP 8, there are a number of new functions being introduced including str_contains, str_starts_with, and str_ends_with, preg_last_error_msg and get_debug_type. In addition, the core PHP 8 engine has many new features, optimizations and improvements in the type system, error handling, and consistency. The key areas include:

  • JIT Compiler
  • Fatal errors on incompatible method signatures
  • LSP Enforcement
  • Resource “Classes”
  • Assertion behavior
  • XML-RPC is now in PECL

  …

  Read more

• MariaDB Now Available Via RPM

  December 7, 2020 Alex Woodie

  When it comes to databases for the IBM i community, Db2 for i is, and always be, number one. But there’s no reason to limit yourself to just one database, and now IBM is making it easier for IBM i shops to get their hands on MariaDB, which could be the number two database on the platform.

  MariaDB is an open source relational database that is a fork of MySQL. MySQL, of course, has been supported on the IBM i server for many years. But following Oracle’s acquisition of Sun Microsystems, which had acquired the company that developed MySQL, …

  Read more

• Open Source The Path To Software Riches For IBM i

  December 2, 2020 Alex Woodie

  For what is supposed to be a proprietary platform, the IBM i server sure has a lot of open source software running on it. In recent months, it appears that the majority of new programs introduced to IBM i are open source in nature. That pattern shows no signs of changing any time soon, according to a recent report by OpenLogic.

  Open software has existed on the IBM i platform for many years. The first highly publicized dip into the open source well occurred in 2005, when IBM partnered with a company called Zend to bring its PHP runtime to …

  Read more

• Db2 And SQL Services Get Upgrades With TRs

  October 12, 2020 Alex Woodie

  Among the biggest enhancements that IBM is bringing to IBM i with the latest batch of Technology Refreshes are new capabilities added to the integrated Db2 database and, specifically, the slew of SQL-based services that retrieve all types of data from the platform for IBM i professionals.

  As we previously told you, IBM has decided to rename SQL Services, which were the collection of pre-defined SQL queries that recreate traditional IBM i commands and sometimes bring something entirely new. The growing gaggle of services (or perhaps it’s a herd?) are now being officially referred to as IBM i services, …

  Read more

• Guru: Scalar Use of LISTAGG

  August 24, 2020 Ted Holt

  The SQL LISTAGG function is as handy as a pocket. Only recently I used it to build a string of comma-separated values (CSV) to populate a drop-down box. It sure beats a cursor and a loop. I’ve noticed in my reading that LISTAGG can be used for both aggregate and scalar purposes under Oracle. Db2 doesn’t support the scalar use, but I found another way to do the same thing.

  To see what I’m talking about, check out example 7 in the article Oracle LISTAGG Function Usage, Tips & Examples, by Ben Brumm. I recommend studying the entire article; …

  Read more

• New Option Emerges for Refactoring IBM i Apps

  August 19, 2020 Alex Woodie

  IBM i shops that want to refactor their RPG and COBOL applications into different languages have a new option available to them. In late June, Astadia and Blu Age announced they’re working together on a new service that automates the conversion of customers’ older apps into Java and .NET code that can run on X86 systems in your basement or the cloud.

  Based in Boston, Massachusetts, Astadia claims to have completed more than 200 mainframe migrations and more than 100 mainframe modernization projects over about two-and-a-half decades. The company has modernized millions of lines of COBOL code running on mainframes …

  Read more

• Guru: Creating PDF Documents With Python

  July 27, 2020 Mike Larsen

  I’m often asked to create reports for my business partners. The format of the report depends on who made the request. If the financial team made the request, I may produce an Excel file. The CEO may want to report quarterly sales to their shareholders. In that case, I may produce a PDF using the company letterhead.

  In a prior article, I showed how to create Excel files using Db2 tables. Now I’m going to show how to create PDF documents using Db2 tables.

  This story contains code, which you can download here.

  I always start by making …

  Read more

• ARCAD Generates APIs From 5250 Screens

  July 22, 2020 Alex Woodie

  Many IBM i shops want to modernize their 5250 applications by developing REST-based Web services and API extensions, but they face difficulties getting started. These organizations may want to check out ARCAD Software’s latest offering, ARCAD API, which takes much of the pain and complexity out of the API generation process.

  REST-based APIs have become a standard method for exposing data and business logic to the outside world. There’s an abundance of ways that APIs can be used–pushing data to Web or mobile users, for example, or pulling data from a cloud-based CRM system. Just about any higher-level application function, …

  Read more

• More Open Source Databases Coming To IBM i

  June 15, 2020 Alex Woodie

  IBM is in the process of bringing several new open source databases to the IBM i platform, including schema-less NoSQL databases as well traditional relational systems. Among the databases that Rochester is targeting are MongoDB, arguably the most popular NoSQL database and a favorite among Web and mobile developers, as well as PostgreSQL, one of the industry’s oldest and most widely used relational databases.

  Databases today almost are like programming languages, with developers mixing and matching databases to handle different functions, often within the same application. DB-Engines.com tracks more than 330 distinct databases, while there are somewhere around 700 programming …

  Read more

Previous Articles