• TRs Deliver Database and SQL Updates for Every IBM i User

  November 2, 2022 Alex Woodie

  When it comes to SQL services and database updates, there’s something for just about every IBM i user in 7.5 TR1 and 7.4 TR7. With dozens of new and enhanced database functions and SQL services, these TRs in fact may be the biggest releases ever, according to Scott Forstie, the Db2 for i architect at IBM.

  During a recent interview with IT Jungle about the new Watson geospatial capabilities that his team delivered in the database (which you can read about here), Forstie pondered the journey he and his team have been on, and how it’s culminated to this …

  Read more

• New Nav Makes Progress, But Still Not Caught Up with Old Nav

  October 26, 2022 Alex Woodie

  The Technology Refreshes have brought IBM closer to completing the transition to the new Navigator from the old Navigator product, which is susceptible to the Log4j security vulnerability. While the advances in IBM i 7.5 TR1 and 7.4 TR7 will help customers, the new Navigator product will still not be at feature parity with old Nav when the plug is pulled on the heritage product at the end of the year.

  IBM has been encouraging its IBM i customer base to accelerate its adoption of the new Navigator, which debuted just over a year ago with the introduction of IBM …

  Read more

• Finally, IBM i Cloud Dev Instances That Are Powerful And Cheap

  October 24, 2022 Chuck Paolillo

  Back in the old days, when IBM had relatively inexpensive entry AS/400 and iSeries machines and was willing to lease them at special low rates to developers, it was possible for software houses and independent code slingers to get their hands on machinery to create and modify applications. Those days are long gone, and it has been very difficult to replace that cheap and usable functionality in the marketplace.

  With Windows Server and Linux platforms, things are a lot easier because developers can create a variant of their X86 server environment right on their desktops or laptops, and if need …

  Read more

• Guru: String Manipulation Using SQL

  October 24, 2022 Mike Larsen

  Recently, I was working with an employee file where first and last name were concatenated with a comma separator. A requirement of the project was to parse the name and populate a different table where first and last name are separate columns. I won’t address the design of the employee file, but I will show how I completed the request.

  In Figure 1, I use the position string function via SQL to extract the first name.

  

   

   

  Figure 1. Extract first name

   

  In this example, I use the trim, substring, and posstr functions to position to the first …

  Read more

• IBM Bolsters Availability, Backup with Latest TRs

  October 19, 2022 Alex Woodie

  Nobody wants downtime or data loss, but companies’ appetite for both are on the decline as customers increasingly demand 24/7 service. IBM i shops have a lot of solutions to choose from when it comes to ensuring uptime and avoiding data loss, both of which have been enhanced with the latest round of Tech Refreshes (TRs) from IBM.

  IBM unveiled updates to its two flagship availability offerings for IBM i with the October 11 announcement of IBM i 7.5 TR1 and 7.4 TR7, including Db2 Mirror and PowerHA SystemMirror for IBM i. It also brought new features to Backup and …

  Read more

• How The Latest TRs Bolster App Dev For IBM i

  October 17, 2022 Alex Woodie

  From Merlin and VSCode to RDi and RPG, good IBM i boys and girls who do their own development will get new toys to play with before Christmas, thanks to a range of new features and functions unveiled by IBM last week as part of its latest Tech Refresh for IBM i.

  The introduction of the IBM i Modernization Engine for Lifecycle Integration, or Merlin, was the big attraction this spring with the launch of IBM i version 7.5 and 7.4 TR6 (it was later made available for IBM i 7.3). The offering, which combines a lightweight VSCode development environment …

  Read more

• Guru: Aliases — Underused and Unappreciated

  October 3, 2022 Ted Holt

  One of the first things I learned about programming in the RPG II language was that field and variable names had to be six characters or less and they did not have to be pronounceable. I accepted this without question, as I was new to computers and figured that everything that had to do with computers was arcane and other-worldly. It wasn’t until I began work toward my computer science degree and was privileged to learn Pascal that I came to appreciate the value of longer identifier names, and of clarity of source code in general.

  You don’t have to …

  Read more

• Remain Hooks TD/OMS Into Azure DevOps

  September 28, 2022 Alex Woodie

  Remain Software’s change management suite for IBM i, TD/OMS, will soon gain support for Microsoft Azure DevOps, providing another code repository for IBM i shops. The Dutch company has a host of other enhancements for various DevOps products — including a new analytics dashboard for KPIs, enhancements to Octo, and new features for its API product — that it’s looking to deliver with next week’s release of Milestone 1. This company is also working on developing an alternative to IBM’s Merlin.

  Remain delivers updates to its various IBM i DevOps products on a regular cadence that starts in early summer, …

  Read more

• Guru: Beware of SQL Precompiler Variables

  September 26, 2022 Ted Holt

  In a famous Henny Youngman joke, a patient says, “Doctor, it hurts when I do this,” to which the doctor replies, “Then don’t do that.” Corny jokes aside, I have spent decades trying to identify programming practices that hurt when I do them, and having identified them, cease to do them. A case in point is the misuse of the variables that the SQL precompiler defines in my RPG programs, variables such as SQLCODE, SQLSTATE, and SQLER3.

  “So what,” I hear you ask, “is the problem with these variables? ” Well, they’re global, and global variables are evil.   Global …

  Read more

• Guru: Regular Expressions, Part 2

  August 15, 2022 Mike Larsen

  In the first part of this series, I showed how to replace characters in a string using SQL and regular expressions. This time, I’ll show other regular expressions that are available for us to use. The regular expression functions I’ll show are REGEXP_COUNT and REGEXP_LIKE and the examples come from production programs that I’ve recently implemented.

  In the first example (Figure 1), I want to get a count of the number of occurrences of a pattern within a string. To make this more interesting, I’m searching for two different patterns within a sting. To accomplish this objective, I used …

  Read more

Previous Articles Next Articles