• Guru: Search Source Code For Strings Using SQL

  October 9, 2023 Bob Cozzi

  The IBM-supplied Find String Using PDM (FNDSTRPDM) command and PDM option 25 are how most developers scan for a simple value in a list of source file members. But what if you need more? For example, what if you want to find something complex, such as the field named “CUST” but not the field named “CUSTNAME” “CUSTOMER” or “CUSTNO”? Go ahead, I’ll wait?

  While I do use FNDSTRPDM all the time, I now use the SQL READSRC (Read Source File Member) Table function more often.

  READSRC SQL UDTF

  The READSRC SQL Table function or UDTF (User-defined table function) uses an …

  Read more

• IBM Releases Db2 For i Extensions For VS Code

  October 9, 2023 Alex Woodie

  Interested in developing new ILE applications in VS Code that utilize the Db2 for i database? Then you’re in luck, because IBM recently created and released vscode-db2i, an open source database extension for Code for IBM i, the uber popular development environment that enables ILE programming in VS Code.

  It is tough to overstate the popularity of Code for IBM i, which Liam Allan created and released just over two years ago. The open source plug-in provides ILE functionality for Microsoft’s VS Code, enabling programmers to write and edit RPG, COBOL, C, and CL code in the lightweight, browser-based …

  Read more

• IBM i PTF Guide, Volume 25, Number 41

  October 9, 2023 Doug Bidwell

  Here is something interesting. There is a new cume for IBM i 7.3, just after it goes out of standard support and is now on extended support. For years, we have been after IBM to put a cume out when it stops supporting a release, kind of a summation at end of life. This is the first time Big Blue has managed to do that.

  It is likely a coincidence, but it should have always been policy. It is difficult to round up docs and PTFs for an end of life product two years after the fact. Having a stake …

  Read more

• Kisco Adds DUO Support to i2Pass, Okta Up Next

  October 4, 2023 Alex Woodie

  IBM i shops that desire multi-factor authentication (MFA) may be interested in the latest release of Kisco Systems’ MFA software, i2Pass, which adds support for the popular authenticator app from DUO. Support for Okta is coming next, the company says.

  DUO Mobile is a popular authenticator app that runs on your smart phone and communicates with server-based MFA and two-factor authentication (2FA) systems to provide more assurance that the person asking for authentication is who they say they are. It was labeled the top 2FA product by the New York Times, which cited its simplicity.

  DUO Mobile users can …

  Read more

• Power10 Upgrade Considerations You Need to be Aware Of

  October 4, 2023 Steve Pitcher

  It has been over a year since Power10 servers have been available from IBM. After many conversations, configurations, proposals, installations, and project debriefs, I wanted to use this article as a point of reflection on some of the nuances around Power10 and the End of Service dates for IBM i 7.3 and Power8 hardware.

  Let’s just jump right into it because we are all busy.

  First: A hardware change is most often used to facilitate the upgrade path to a newer version of the IBM i operating system.

  The Power8 servers top out at supporting IBM i 7.4. They’re …

  Read more

• Eradani Debuts DevOps Suite for IBM i

  October 4, 2023 Alex Woodie

  It’s been five years since Dan Magid, the former CEO of Aldon and an executive with Rocket Software, has been involved in the IBM i change management and DevOps business. But with next week’s launch of Eradani DevOps at COMMON’s NAViGATE conference, the longtime change management expert is getting back into the game. This time, however, Magid is taking a decidedly different approach.

  What makes Eradani DevOps stand out from other change management tools on IBM i is its focus on open source tools. The folks at Eradani have realized that application developers in the mainstream IT world have pretty …

  Read more

• Four Hundred Monitor, October 4

  October 4, 2023 Jenny Thomas

  Investing in the future of the IBM i is not something we hear much about. So, when we learned about a new fellowship program from Kisco Systems, we were all ears. The goal of this new program is to encourage IBM i customers to launch careers by helping them develop IBM i skills in house. Applicants for the fellowship must be sponsored by an active IBM i customer and will receive: free IBM i and RPG training; a one-year COMMON membership including registration for two conferences; and recognition in the IBM i community through podcasts and the COMMON Education Foundation. …

  Read more

• This Is Your IBM i Market, And Therefore Your Annual Survey

  October 4, 2023 Timothy Prickett Morgan

  It has been a decade since the IBM i Marketplace Survey was conceived of by the late Dan Burger of IT Jungle and Tom Huntington of HelpSystems, now known as Fortra. We miss Dan a lot, and you don’t want to miss a chance to help the community better understand itself, which is what all of us at IT Jungle and at Fortra really are after as we ask you, once again, to take the survey.

  We are coming into the home stretch of the 10^th annual IBM i Marketplace Survey. That means time is running out for you …

  Read more

• 40 Years Of DB2, But Even More For That No-Name Database Embedded In The System/38

  October 2, 2023 Timothy Prickett Morgan

  Last week, Big Blue celebrated the 40^th anniversary of the launch of its Database 2 relational database management system for its venerable System/370, System 308X, and System/390 mainframes. It is now called Db2, because marketing people can’t leave anything alone, and even though we now have this thing called Db2 for i, IBM didn’t mention this red-headed stepchild of a relational database as part of its celebration.

  Not even once. And that’s just fine by us because the integrated relational database management system that has been the heart of our venerable System/38 and its progeny was never DB2/400 or …

  Read more

• API Dev Tool Delivers For Trucking Outfit

  October 2, 2023 Alex Woodie

  When the IT leaders at Ward Transport & Logistics set out to find a product that would allow them to call outbound APIs from their IBM i server for a new dynamic pricing system, they had an inkling of what they wanted. But when they looked for an API development tool in the IBM i market, they were surprised at what they found.

  From its headquarters in Altoona, Pennsylvania, Ward Transport & Logistics provides less than truckload (LTL) service to customers throughout the region. The company’s 1,600 employees help Ward’s customers move freight with a fleet of 750 power units …

  Read more

Previous Articles Next Articles