• Consider Modernizing Your Approach to IBM i Security, Too

  November 10, 2021 Alex Woodie

  Many IBM i users are facing the reality that they need to modernize their IBM i applications, especially those based on monolithic blocks of fixed-format RPG. But other aspects of the IBM i experience can use some renovating too, including how organizations manage their security settings. Luckily, in the last few Technology Refreshes to IBM i, IBM has provided a slew of new SQL-based services for doing just that.

  Traditionally on IBM i, administrators had two main approaches for viewing and changing security settings. They could view and control the settings directly using commands, often automated through CL programs. Or …

  Read more

• Guru: Flexible Interfaces

  November 1, 2021 Ted Holt

  The details are murky, it’s been eons ago. Probably the mid-1990’s. I was working on an AS/400 that ran a mixture of System/36 and native applications. I needed to call a program that had been written in the latest version of RPG from both S/36 RPG II and native RPG III (a.k.a. RPG/400) programs. I hope I’m remembering this correctly. It’s been so long.

  The problem I ran into was rooted in a numeric parameter. S/36 programs passed numeric parameters in zoned decimal format, whereas native RPG and CL programs used packed decimal. The called program defined the parameter as …

  Read more

• Expanding Fields Is A Bigger Pain In The Neck Than You Think

  October 20, 2021 Andrew Ireland

  Remember the Y2K problem, when companies had two-digit dates for years in their applications and the millennial turn was coming and they suddenly needed a four-digit date so all the math would work out right comparing the present, future, and past? Well, every time you need to change a field length in your source code – which almost always means making it bigger, not shorter – you have to suffer through a mini Y2K crisis.

  Yes, the Y2K crisis did not bring an end to civilization as we knew it, as some were prognosticating and maybe a few were hoping, …

  Read more

• Every IBM i Shop Must Have An API Integration Strategy

  October 6, 2021 Daniel Magid

  I have had several very exciting conversations with IBM i users recently about new technology as they have reached out to Eradani for help in advancing their IBM i applications using APIs. More and more I hear how IBM i pros are learning new things and innovating to transform their IBM systems into examples of leading-edge computing. One of the cool things IBM i users are recognizing is that the value of APIs comes not just from making IBM i data available to other applications and outside users, but also from adding additional function to RPG applications by calling out …

  Read more

• Db2 PTF Group Enhancements Target Web Services, Audit Journal

  October 4, 2021 Alex Woodie

  It is indisputable that the Db2 for i database is the beating heart of the IBM i platform. There were no earthshattering enhancements to this database in the latest batch of Technology Refreshes for IBM i 7.3 and 7.4 that IBM announced and shipped last month. But there were a few items worth mentioning that shipped in the Db2 PTF Group, including new HTTP commands for calling the database via REST and new SQL-based commands for querying the security audit journal.

  The top new Db2 for i feature arguably is the new set of functions for HTTP requests to consume …

  Read more

• Fresche Takes On New RPG Development And Modernization With X-Elevate

  September 27, 2021 Timothy Prickett Morgan

  Over the years, Fresche Solutions, the IBM i conglomerate that is focused on development of new applications as well as modernization of existing applications, their interfaces, and their databases, has acquired and built tools that help programmers create Java and PHP programs, or convert RPG applications to Java and PHP. But by its own admission, Fresche did not focus on new RPG application development or the kind of incremental programming that a lot of IBM i shops are doing to gradually modernize their applications, usually through the shift from fixed format RPG to the free form RPG that is similar …

  Read more

• Guru: RDi 9.6, Part 11 – New Features for Experienced RDi Users

  September 20, 2021 Susan Gantner

  Just when you thought my multi-part series on V9.6 of RDi was surely finished, it’s back! It seems like the song that never ends. Happily, though, since more new features have been added to RDi, many of which are the direct result of RFEs (a.k.a. Requests for Enhancement) from RDi users like you and me.

  We’ve waited longer than usual for release 9.6.0.11, but it’s available now. I’ll cover the enhancements in this release in a couple of tips. This first tip will target mostly experienced RDi users. The next one will focus on some of the enhancements to ease …

  Read more

• New Extension Brings IBM i Closer to VS Code

  August 11, 2021 Alex Woodie

  When it comes to integrated development environments (IDEs), Microsoft is best known for its full-featured Visual Studio offering. But many developers have grown attached to its younger, free-er, and lighter weight cousin, Visual Studio Code (VS Code). And with the new VS Code for IBM i extension recently unveiled by Liam Allan, the skinny IDE’s integration with the midrange server is getting better.

  VS Code for IBM i is an open source extension that allows developers to work with IBM i languages like RPG, COBOL, and CL within VS Code. Allan first released the product in February, but largely kept …

  Read more

• Taking A Camel-First Approach to Integration

  August 11, 2021 Alex Woodie

  Unicorns and Chupacabras may not exist on this planet, but camels certainly do. And according to midrange open source guru Jesse Gorzinski, IBM i shops would do well to take a camel-first approach to integration challenges.

  The camel, of course, is Apache Camel, the Java-based integration framework that’s designed to connect two or more systems. During the recent OCEAN TechCon21 conference, Gorzinski, IBM’s business development manager for open source on IBM i, presented a compelling overview of Camel and how it can benefit administrators and developers in an IBM i environment.

  “Apache Camel can make it pretty easy to …

  Read more

• Guru: Getting Meaningful Audit Information from a Journal

  July 26, 2021 Paul Tuohy

  Journaling is an invaluable tool that is used for data recovery, data replication, commitment control and, of course, auditing. But getting at the audit information in an easy-to-use manner can be cumbersome. In this article I want to introduce you to a stored procedure that will create an audit table for any table/physical file and a corresponding view that can be used for easy auditing of changes.

  For example, if I am auditing the EMPLOYEE table (I will be using the EMPLOYEE table in the standard Db2 Sample Database) for a change to the SALARY column, I would use the …

  Read more

Previous Articles