• IBM i PTF Guide, Volume 25, Number 4

  January 23, 2023 Doug Bidwell

  Here are some reminders to start off the IBM i PTF Guide this week.

  First, there are new releases for Access Client Solutions and the ODBC database driver. (See ACS_NAV in the Guide for the links.) The funny bit – funny odd, not funny hilarious – is that version 26 of ACS did not allow companies to create a database source for ODBC, which is serious shortcoming. Now, there is a new version 27 that will let you do it. Here is the updated software:

  Description				   Version
  IBM i Access Client Solutions (1.1.9.1)	   1.1.9.1
  ACS Windows App Pkg English (64bit)	   

  …

  Read more

• 2023 IBM i Predictions, Part 1

  January 16, 2023 Alex Woodie

  What will happen in the IBM i world in 2023? Your guess is as good as ours, which is why we have corralled some of the most respected names in the industry to gaze into their crystal balls and give their prognostication for the year to come.

  Donnie MacColl, the senior director of technical support and GDPR data protection officer at Fortra (formerly HelpSystems), kicks off this year’s batch of predictions with an expectation of more automation, thanks to a lack of skilled employees.

  “Automated operations will accelerate along with migration to the cloud,” MacColl tells us. “Automation is key …

  Read more

• Top 5 New IBM i Features to Check Out Now That Fall TRs Are GA

  December 7, 2022 Alex Woodie

  All of the new features that IBM unveiled earlier this fall with the Technology Refreshes for IBM i 7.4 and 7.5 (as well as another stealth “non-TR” TR for 7.3) are now generally available. Some of them shipped before December 2, but pretty much all of them are now GA. With so much enterprise computing goodness ready to download, what will you adopt first?

  We know it’s not Christmas yet. But with so many new features, it can be hard to figure out what to do first. While everybody has their own computing priorities, we have our own ideas for …

  Read more

• Thoroughly Modern: A Swiss Army Knife For IBM i Developers

  December 5, 2022 Robert Arce

  Our strength as developers and programmers lies not only in the code we write, but also in the tools we choose to surround ourselves with. The right tools are often the determining factor in how productive, efficient and accurate we can be – especially when working with large applications that we didn’t even write.

  Long gone are the days of just managing a handful of programs, technologies, languages or databases, and relying on tribal knowledge to make critical business decisions isn’t just risky, it’s irresponsible. Especially when more and more experienced IBM i (AS/400) developers are changing jobs or retiring …

  Read more

• 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

Previous Articles Next Articles