• 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

• 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

• CNX Turns The Crank On Valence

  August 7, 2023 Alex Woodie

  CNX recently launched a major new release of Valence, its development framework for creating Web-based applications for IBM i. With version 6.2, CNX has added a number of new features that assist with improving the appearance and functionality of screens, new RPG toolkit procedures, and better SQL parsing for database interactions.

  CNX’s Valence story stretches all the way back to 2001, when the Chicago, Illinois-based development and consulting shop started developing a third-party planning system that SSA (now Infor) BPCS customers could plug into their ERP systems. That early work on ATOMIC, as it was called, eventually turned …

  Read more

• Guru: Binding Directory Entries

  June 5, 2023 Bob Cozzi

  I assume you’ve heard about *BNDDIR (Binding Directory) objects introduced circa 1994 with OS/400 V3R2. The infamous QC2LE binding directory is used by a huge number of RPG applications to access C runtime and unblocked MI functions such as system cvthc, cpybytes, and matmatr. You have probably seen RPG IV source code with the BNDDIR(‘QC2LE’) keyword on the header specification.

  I was one of the first developers outside of IBM to use Binding Directories for my own code. When I go back and look at my own RPG IV code created prior to mid-2007, well over 90 percent of it …

  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

• 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

• 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

• 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

• Why Infor’s IDF Is Important for Customer Innovation

  May 25, 2022 Alex Woodie

  Among the remaining large ERP vendors targeting IBM i, Infor appears to be the most committed to ongoing development on the platform. A key element of that strategy is the Infor Development Framework (IDF), which plays a big role in extending the functionality in its IBM i-based ERP systems to meet customers’ specific needs.

  The IDF features most prominently in Infor’s long-term strategy for the ERP XA (MAPICS), ERP LX (BPCS), and ERP System 21 product lines, says Robert Russel, the vice president of product development at Infor.

  “We’re starting to try to essentially get that technology embedded into …

  Read more

• API Operations Management for Safe, Powerful, and High Performance APIs

  May 18, 2022 Daniel Magid

  Now that API enablement for IBM i applications has become mainstream, IBM i users are starting to ask questions around how best to manage API operations. To get the most out of your APIs and to provide your API users with the very best experience, you must:

  • Ensure your APIs are up, running and providing rapid responses.
  • Protect your APIs from attacks, misuse and faulty calls coming from API end users.
  • Have a strategy for creating, deploying and maintaining your APIs over time.

  In other words, you need to make sure that your APIs deliver the same reliability, security, performance …

  Read more

Previous Articles Next Articles