• IBM i PTF Guide, Volume 26, Number 41

  October 21, 2024 Doug Bidwell

  Don’t get hyper about HIPERs, but there are some issues you need to deal with if you have moved to IBM i 7.5. High Impact / Highly Pervasive (HIPER) Issue Potential undetected data loss can occur on LPARs using NPIV with certain Fibre Channel adapters. Potential undetected data loss can occur on LPARs using NPIV over Fibre Channel adapters with the following Feature Codes:  EN1E/EN1F, EN1G/EN1H, EN1J/EN1K, EN2L/EN2M, and EN2N/EN2P.

  You can read about this HIPER PTF at this link.

  Now, there are also two security vulnerabilities on this week’s To Do list.

  First, we have Security Bulletin: IBM …

  Read more

• Eradani Taps GenAI for IBM i Integration Boost

  October 9, 2024 Alex Woodie

  Eradani introduced a new product last month that uses the power of generative AI to simplify the development of code for integration projects involving IBM i. The company says the new product, dubbed Eradani Assist, will allow customers to use natural language to tell the product to build specific application and data integrations, and the product will leverage one or more large language models (LLMs) to generate the integration code.

  Eradani calls its flagship product, Eradani Connect, an “integration hub” that manages communication into and out of the IBM i platform. The software supports application and data integration projects that …

  Read more

• IBM Bolsters Data and App Integration with webMethods, StreamSets Acquisitions

  July 10, 2024 Alex Woodie

  IBM i shops are among the customers that could benefit from IBM’s completion of its acquisition of webMethods and StreamSets, which it announced last week.

  In mid-December, IBM announced an agreement had been reached with Software AG and Silver Lake, the private equity firm that owned a majority of Software AG, to acquire webMethods and StreamSets for €2.13 billion, or $2.32 billion per the conversation rate at the time.

  The two deals significantly bolster IBM offerings in the fields of data and application integration, which are areas of growing concern due to the rising popularity of artificial intelligence and the …

  Read more

• Guru: Web Concepts For The RPG Developer, Part 2

  June 10, 2024 Chris Ringer

  Hello again! Part 1 of Web Concepts for the RPG Developer was an introduction on how to build components in an HTTP request and I hope you enjoyed it. Part 2 is just a continuation of that vast topic because there is so much to learn. I encourage you to click on the links in this article and explore on your own too.

  JSON

  A web API endpoint may require the data in the body of an HTTP POST request to be constructed as JSON (“jay sahn,” short for JavaScript Object Notation). JSON is formatted text (a string) containing key:value …

  Read more

• Eradani Lays Waste to API Payload Restrictions

  November 15, 2023 Alex Woodie

  Eradani Connect customers who need to pass large amounts of data to IBM i via external API calls have often been stymied by a built-in restriction in IBM i that limits their payload to a mere 16MB. Those customers will be thrilled that Eradani has launched a new big data connector that smashes those payload restrictions to smithereens.

  Eradani Connect is a packaged application designed to simplify the creation and execution of API calls on IBM i. The software functions as a middleware layer that makes it easy for .NET, JavaScript, and Python developers to get access to the IBM …

  Read more

• Guru: The Transition From Modern RPG IV To Modern SQL

  October 30, 2023 Bob Cozzi

  Seven or eight years ago I was working with a client who needed more contemporary reporting than provided by the legacy Query/400 product. Initially I looked at Db2 Web Query and realized the documentation was sparse and the tutorials for most things, even “getting started” were virtually non-existent. It was also about four times more expensive than I felt it was worth to a P05 or P10 client. I mentioned the documentation issue to the folks at IBM and they agreed. Some of it was eventually resolved, but not enough in my opinion to get the masses to replace Query/400 …

  Read more

• What the Latest ALL400s Survey Tells Us About the IBM i Community

  October 18, 2023 Alex Woodie

  What is the most popular development tool in the IBM i community? What technology exists in nearly every shop? What BI tools are in use? And what activities are sitting in the IT backlog’s of IBM i shops? These are some of the questions that ALL400s answered with the latest edition of its IBM i community survey.

  You may have heard about ALL400s as the comprehensive list of IBM i customers around the world. John Rockwell, the Florida man behind ALL400s, does his best to keep the list as updated as possible.

  In addition to the list, Rockwell has put …

  Read more

• Guru: Generating XML Using SQL – The Easy Way

  September 18, 2023 Bob Cozzi

  There are many verbose methods of generating XML. You can:

  • Write your own RPG code
  • Using a free or third-party API
  • Use SQL iQuery OUTPUT(*XML) option
  • Use the built-in SQL XML functions such as XMLELEMENT

  I’m sure there are others, but these seem to be the most popular.

  For years I had been using the XMLELEMENT approach; a rather verbose set of XML function built into Db2 for i SQL. In fact, SQL iQuery’s OUTPUT(*XML) is based on that feature. It simply regenerates your SQL statement using XMLELEMENT statements for each output column/field name.

  But if you’re using something IBM …

  Read more

• Kafka, JSON, DevOps: Future Proof Your IBM i With Secure, High Performance APIs

  October 26, 2022 Daniel Magid

  It is an exciting time to be working with an IBM i! The Rochester lab and IBM partners are rapidly pushing out new technology options that allow you to do anything with the IBM i that you can do on any other platforms. The latest in web and mobile user interfaces, the most modern languages, comprehensive security, machine learning, data visualization, internet of things, APIs – are all available to IBM i users. When combining all that technology with the unmatched reliability, ease of management and low cost of ownership of IBM i, you can be confident that your company …

  Read more

• Smart Modernization Is The Answer To IBM i Talent Shortage

  September 28, 2022 Jose Caso Jacobs

  When we are at the COMMON POWERUp 2022 conference a few months ago, we were amazed by the number of IT managers that approached us because of a shortage of IBM i programming talent. The dearth of programmers that are experienced with the business as well as legacy and modern programming techniques has pushed a lot of businesses up against the wall, with lost agility and in some cases delayed projects.

  As bad as that is, the situation could be worse. We have all heard the horror stories, where the executive suite or upper IT management push to switch away …

  Read more

Previous Articles