• IBM i 7.3 And 7.4 Get Their Autumn Tech Refreshes

  October 9, 2019 Timothy Prickett Morgan

  Big Blue is hosting its IBM Systems Technical University this week, and used the occasion to quietly launch the Technology Refreshes, or TRs as they are known, for IBM i releases 7.3 and 7.4. If you were running around the Venetian Hotel, you could probably stitch together the extent of the updates to the platform, and to be honest, we are still trying to get all of the details, which were not available as we went to press.

  We will tell you what we know now, and then circle back and drill down into the details as appropriate.

  First of …

  Read more

• Guru: Parsing JSON With DATA-INTO And A Twist

  September 23, 2019 Mike Larsen

  One of my recent projects required me to parse JSON returned from a web service. On the surface this sounded like a pretty easy task, but I quickly ran into a challenge. The JSON being retuned didn’t have a top-level element, and since I wanted to load the JSON into a data structure, my program couldn’t handle it.

  After some searching, I found that some of my options included changing the code in the parser (JSONPARSE) or using a totally different parser altogether. While both of these are viable options, I decided to take a slightly different route.

  Before I …

  Read more

• 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

Previous Articles