• 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

• IBM i Gets a New Crop of ‘Fresh Faces’

  June 12, 2019 Alex Woodie

  The IBM i platform isn’t getting any younger, and neither are the thousands of individuals who work on it. But that doesn’t mean that platform as a whole should be marked by gray. To celebrate the viability of the platform’s ability to attract young people, IBM System Magazine just introduced its newest crop of “Fresh Faces.”

  IBM System Magazine has been calling attention to the IBM i youth movement since 2016, when it debuted its original crop of Fresh Faces. Liam Allan was a member of that group as a teenager, and he has since gone on to build himself …

  Read more

• Fresche Bullish On ‘Factory’ Approach As IBM i Market Improves

  June 5, 2019 Alex Woodie

  Factories offer a level of repeatability, predictability, and efficiency that make the manufacture of goods simpler, less risky, and more profitable than it would otherwise be. Now the folks at Fresche Solutions are taking a factory-based approach to a markedly different endeavor: the modernization of IBM i applications. The early returns from Fresche indicate some optimism may be in order.

  Last week at the POWERUp conference in Anaheim, California, Fresche Solutions CEO Andy Kulakowski and his team spoke at length with IT Jungle about its new factory approach to selling modernization software and services, as well as the recent successes …

  Read more

• Speaking The SQL Lingua Franca On IBM i

  June 3, 2019 Timothy Prickett Morgan

  No matter what the job is, we all start out somewhere that is pretty far from being an expert and we depend on our elders and mentors to help us learn all the tricks and get good at the work.

  So it is with the nearly ubiquitous database query language, Structured Query Language, or SQL for short. It started out in the head of IBMer Ted Codd back in 1969, which was coincidentally when the System/3 minicomputer launched and its successor many generations later, the System/38 in 1978, was the first IBM system and the first system in the world …

  Read more

• Guru: 7.4 Brings New RPG Goodies

  June 3, 2019 Jon Paris

  As I’m sure you know by now, IBM recently announced version 7.4 of IBM i. Along with major enhancements such as Db2 Mirror, we also got a number of new RPG features. In this tip I’ll cover those that are already available in 7.3 via PTF. The 7.4-only enhancements will be covered in a subsequent tip.

  Before we get into the details of the 7.3 features, just a hint of what is to come . . . 7.4 brings the long-awaited arrival of dynamic arrays known to IBM as varying dimension arrays. No more do you have to compromise between …

  Read more

• These POWERUp Sessions Are About the Recent IBM i Announcement

  May 15, 2019 Alex Woodie

  Disneyland didn’t complete construction of Star Wars Galaxy’s Edge in time for next week’s POWERUp conference. But luckily for you, IBM did finalize its IBM i announcement soon enough for COMMON’s annual extravaganza, making next week’s show in Anaheim, California, a great chance for you to learn about the new releases of the operating system, including IBM i 7.4 and 7.3 TR6.

  According to COMMON’s online session guide, there are at least 16 sessions at POWERUp 19 having to do with IBM i 7.4, IBM i 7.3 Technology Refresh 6 (TR6), or the new software that will arrive with …

  Read more

• IBM Bolsters RPG And COBOL Development

  May 13, 2019 Alex Woodie

  Amid the many and varied enhancements that IBM rolled out last month for its IBM i operating system was a collection of improvements for its core development tooling, including the Eclipse-based Rational Developer for i (RDi) as well as Rational Development Studio for i, which contains the RPG and COBOL compilers.

  Let’s start with the RPG and COBOL compilers in Rational Development Studio for i, since updates to these strategic pieces are more infrequent than the updates to RDi, which shares a common base with integrated development environments (IDEs) for other operating systems and therefore updated more frequently.

  The biggest …

  Read more

• Guru: Emulate Control Break Reporting With DB2 For i SQL

  May 13, 2019 Michael Sansoterra

  When generating ad hoc user reports, it’s often the case that developers don’t have the time or luxury to write a high-level language program or to use a reporting tool such as DB2 Web Query or Crystal Reports to format the data appropriately. But when a user is given a raw dump of a SELECT statement’s result set in Excel, it can be quite ugly to wade through and format.

  The user may have to do things like add total rows or remove duplicate values, which can be quite time consuming. Thankfully, DB2 for i SQL offers a way to …

  Read more

• Does Db2 Mirror Kill The Market for Third Party HA?

  May 6, 2019 Alex Woodie

  IBM launched Db2 Mirror for i two weeks ago to great acclaim, as the clustering technology puts IBM i on par with how most other major systems provide continuous availability. But will Db2 Mirror destroy the platform’s heritage of high availability solutions? IT Jungle asked IBM and the biggest providers of logical replication solutions, and the answer is no. Here’s why.

  The first thing to understand about Db2 Mirror is that, at heart, it’s a database clustering technology. IBM figured out a way to make a single instance of Db2 for i run on two separate systems, in an active-active …

  Read more

• Guru: Open Access To The Rescue – The Next Step

  May 6, 2019 Jon Paris

  I recently wrote a tip on using an Open Access handler to enable the creation of flat files in the IFS. In that version of the handler I generated a generic file name and used hard-coded record delimiters and code page settings. I mentioned at the time that I would normally supply these values at run time. In this follow-on tip I describe how the handler can be modified to use the Open Access User Parameter to facilitate this.

  The User Parameter is simply specified as a second parameter to the HANDLER keyword. It can be a simple variable or, …

  Read more

Previous Articles Next Articles