• Guru Classic: The Efficiency of Varying Length Character Variables

  August 14, 2019 Jon Paris

  Remember the bad old days when dinosaurs still roamed the earth and the only way to build strings in RPG involved playing silly games with arrays? Or worse still, obscure combinations of MOVE operations? Thankfully those days are far behind us — although sadly there are still a few RPG/400 dinosaurs coding away!

  RPG IV introduced many powerful new string handling options, such as the %TRIMx family of BIFs, but even now there are capabilities in the language that few programmers fully exploit. One of my favorites is variable length fields. This lack of familiarity made this tip an obvious …

  Read more

• Eradani Bridges The Gap Between Legacy And Open Source

  July 8, 2019 Timothy Prickett Morgan

  In this publication, legacy is not a dirty word or even remotely pejorative. Rather, “legacy” is just a shorthand way of delineating between applications that encapsulate decades of the evolution of a business and the transactions it processes, and all of the other new stuff that this business is also doing and perhaps coding with newer tools and programming languages.

  A new company, called Eradani, has been founded by some experts in both the IBM i world and the open source world with the express purpose of building a technical bridge so these two different cultures can see a …

  Read more

• CNX Welcomes 5250 Apps Into Valence Framework

  June 12, 2019 Alex Woodie

  For years, CNX has prided itself on providing the IBM i community with development tools for creating modern Web applications on the platform. The company looked unapologetically to the future, and encouraged customers to move on from their green-screen pasts. But in response to strong customer demand, the company has relented and decided to allow green screens into the framework via an innovative new Web-based emulator dubbed Fusion5250.

  Fusion5250 is all about giving customers choice, CNX says. The software, which is a core new feature in Valence 5.2+, lets Valence customers access a modern application developed with CNX’s Nitro App …

  Read more

• BMC Touches Clouds with Job Scheduler

  March 20, 2019 Alex Woodie

  Clouds are growing quickly as IT executives look to find more flexibility and cut costs by adopting cloud and software as a service (SaaS) applications. But most enterprises aren’t getting rid of all their on-premise systems, which means somebody needs to connect those cloud and on-premise systems. One of those “somebodies” is BMC Software.

  You might not remember it, but BMC Software still actively supports the IBM i environment with enterprise job scheduler, called CONTROL-M. The Houston, Texas, company has supported the IBM midrange server for years, and continues to do so with the 19th version of CONTROL-M, which the …

  Read more

• Guru: When Playing With SQL

  March 18, 2019 Paul Tuohy

  One of the questions I have been asked a lot at conferences is “How do you figure out x in SQL?” In this article, I will discuss four things I use a lot when playing with SQL in Run SQL Scripts: VALUES, SYSIBM.SYSDUMMY1, global variables, and the system catalog.

  VALUES

  When I am trying to figure out how an SQL function works, my first port of call is the VALUES statement. VALUES derives a result directly from an expression. For example, the following statement:

  values upper('paul');
  

  Would generate the following result set:

  

  You can specify more than one value in …

  Read more

• Building Out The .NET Stack Around Mono for IBM i

  March 13, 2019 Alex Woodie

  The first release of a Mono .NET port to IBM i was issued last year. Since then, the IBM i open source community has been busy building many of the other middleware components that will make it easier for developers to build IBM i applications using Microsoft tooling.

  Mono was ported to AIX and IBM i (via the PASE AIX runtime) last year, which gave IBM i and AIX shops the capability to run the open source .NET runtime on Power Systems servers, thus opening the door to allowing Microsoft‘s highly regarded suite of development tools to be …

  Read more

• Guru: Change XML Elements in SQL

  February 18, 2019 Paul Tuohy

  Over the last few years, it has become more common to store XML or JSON in a column in a table. Whereas SQL provides all the necessary functions to construct/deconstruct XML or JSON from/to relational data, it does not provide an easy means to change the contents of an element. In this article, I am going to demonstrate a technique for changing the contents of an XML element using an SQL stored procedure.

  Just to provide some background, I was recently working on a project where DB2 XML Extender functionality was being replaced with the standard XML functions. The project …

  Read more

• Taking A Fresche Approach To IBM i-Watson Education

  February 4, 2019 Alex Woodie

  There is a big data analytics revolution taking place that threatens to separate the AI haves from the have-nots. Companies that run the IBM i server want to get in on the analytics action just like everybody else, but AI discussions often stray away from IBM i. Now Fresche Solutions is working to close that disconnect with a series of educational courses centered squarely on the intersection of IBM i and Watson.

  Last year, Fresche Solutions worked with IBM last year to put together a series of onsite training seminars aimed at giving IBM i professionals the educational tools they …

  Read more

• Scaling Up For Cyber Monday With IBM i

  November 26, 2018 Alex Woodie

  A fulfillment company that’s expected to process millions of transactions on an IBM i server today will lean heavily on a slim layer of RPG-based Web services technology to keep the commerce flowing for its large clients. But there’s nothing stopping the middleware, dubbed iWebSrv, from simplifying data integration for clients in other industries.

  Retailers work all year to ensure they’re ready for the massive surge of traffic that springs up after Thanksgiving. For bricks-and-mortar types, Black Friday is their make-or-break day, while those with an omni-channel bent have Cyber Monday prominently circled on their calendars.

  Consumers are expected to …

  Read more

• Break Out Of Your RPG Comfort Zone

  October 29, 2018 Amanda Blackburn

  (Sponsored Content) IBM i developers, like all developers, can get stuck in a rut sometimes. The well-worn path that RPG provides is familiar and reassuring, but it doesn’t necessarily lead your company where it needs to go. That’s why exploring newer IBM i language alternatives, like Node.js, can provide a fresh path towards the goal of business innovation.

  The rapid ascent of the Node.js programming language over the past five years has been well-documented. While Java remains a popular business language, Node.js is now the world’s most popular development framework in all of computing, according to the 2018 …

  Read more

Previous Articles