Entries by Alan Seiden

Use Those IBM i Service Vouchers — Program Ends In 2025

One of the best deals in IBM i services is about to end. Effective January 1, 2025, the “IBM i Service Voucher for Power” program is being withdrawn. The program has long provided Power hardware customers with vouchers for Expert Labs consulting. (Expert Labs was formerly known as Lab Services.) Many companies are not even aware that they are entitled to vouchers.

Compare Source Code with VS Code for IBM i

Code for i’s source comparison feature recently helped me find a bug. While comparing old vs. new versions of an RPG program, I discovered that a CHAIN had been changed to an SQL SELECT, which was fine, except that an important column name had been forgotten. I created a “before and after” Code for i screen shot for the programmer, who then fixed the mistake. As documented on the Code for i “Tricks” page, comparing source code takes only two steps. This technique works both for traditional source members and stream files stored in the IFS.

How Current Are Your PTF Groups? Find Out Using SQL

IBM i continues to deliver SQL interfaces to simplify our work and keep our technology current. Example: We recently needed to test an issue with Apache HTTP Server for i for a support client. IBM Support requested that we check for the latest HTTP PTF Group on our server. (PTF Groups are the names given to logically related fixes, such as those related to HTTP.) To find out if we had the most current group, we used the  SYSTOOLS.GROUP_PTF_CURRENCY SQL view. 

“BOB” for IBM i: Demonstration by Edmund Reinhardt

At Seiden Group’s September 13, 2024, Code for i Fridays meeting, IBM’s Edmund Reinhardt presented a one-hour tutorial on the Better Object Builder (BOB). This comprehensive demo was given by request. A regular attendee had asked for a complete demonstration, start to finish, of how to use BOB to compile source in VS Code; prepare a make file from scratch; and to use Source Orbit. These tools can help developers who wish to use Git with stream files instead of traditional QSYS-based source members.

Code for IBM i Fridays: A Free Seiden Community Event

The Code for i extension to Visual Studio Code (VS Code) has become ever more popular and powerful. It’s also free and open source. Seiden Group has been hosting online gatherings to share, learn, solve problems, and contribute improvements to Code for i. Hosted by Alan Seiden, the meetings often include guests such as Liam Allan, the originator of Code for i.

Which PHP Versions Get Critical Security Updates?

Although there are many reasons—including performance—to update to newer PHP releases, the number one reason is to avoid losing security updates. Each version of PHP (7.4, 8.0, 8.1, 8.2, 8.3, etc.) has three years of support before it is considered end of life. For two years, it gets bug fixes and all security fixes. In the third year, it gets only critical security fixes. After that, nothing!

How to Protect Secure Websites & APIs from Certificates Expiring

If you have encrypted your website, API, Telnet server, or other service with TLS (SSL), good for you! Now, do you know when those certificates will expire? If they expire without renewal, your service could become unavailable without warning. In the past, to find expiration dates for digital certificates on IBM i, you’d either have to look in the Digital Certificate Manager (DCM), call the Retrieve Certificate Information (QYCURTVCI, QycuRetrieveCertificateInfo) API, or keep extremely good notes! CERTIFICATE_INFO, an IBM i service recently delivered by IBM, solves all this. This SQL table function, documented here, returns a result table that contains…