• COBOL Is Not The Problem; The Data Is

  June 1, 2020 Brad Thomas

  The COVID-19 pandemic has put a spotlight on COBOL, with multiple news stories about COBOL systems struggling as unprecedented demands have been placed on them. And then there are the urgent requests for COBOL developers to help ensure these mission-critical systems do their jobs.

  Eventually, the dust will settle, but some tough decisions will loom for organizations that rely on COBOL. The reality, though, is these decisions were already on the horizon because of the constant evolvement of other data management technologies, surging data production and the rapidly increasing average age of COBOL developers. When the dust does settle, it …

  Read more

• Guru: Introduction to the Administration Runtime Expert

  June 1, 2020 Dawn May

  Business-critical applications must be up and running reliably without failure. When something unexpected occurs, you must identify the cause and correct it quickly. Whether you’re a developer launching a new application, enhancing an existing application, or maintaining a legacy application, or an administrator managing the infrastructure, we all want to find ways to make our jobs easier, and unexpected surprises are not fun. I expect the relentless push to do more with less is only going to intensify while the tolerance for failure keeps dropping. Yet identifying points of failure can be tricky as complexities scale.

  IBM i offers a …

  Read more

• What’s New With Db2 Web Query?

  May 11, 2020 Alex Woodie

  Db2 Web Query, which is IBM’s strategic business intelligence tool for IBM i, doesn’t follow the same release cycle as the operating system itself. But as part of activity surrounding the latest round of Technology Refreshes (TR) for IBM i 7.3 and 7.4, IBM discussed the recent updates that it’s made to Db2 Web Query, along with new features that are due very soon.

  To get the lowdown on the new Db2 Web Query features, we tuned into a recent presentation made by Doug Mack, IBM’s Db2 Web Query product manager. Mack presented a session with Db2 for i …

  Read more

• What’s New In Open Source With The Latest TRs

  April 27, 2020 Alex Woodie

  New technology is exciting. And when it can help you run your business more profitably or efficiently, well, it becomes very exciting. With IBM i, the open source community is arguably the biggest contributor of new technology to the platform. IT Jungle recently checked in Jesse Gorzinski, the IBM i open source architect, to hear how the open source story has improved with the recent technology refreshes.

  Arguably the biggest open source-related enhancement with IBM i 7.4 TR2 and 7.3 TR8 revolves around a change in RPM, the new delivery method that IBM adopted two years ago to distribute new …

  Read more

• Database Enhancements Galore In Technology Refresh

  April 20, 2020 Alex Woodie

  Db2 for i is the beating heart of the IBM i server. There’s no doubt about that. So when IBM delivers the next set of Technology Refreshes (TRs) for IBM i 7.3 and 7.4 next month, you can bet that they’ll be loaded with new and improved features to keep the database humming.

  To get up to speed with the database-related enhancements in IBM i 7.4 TR2 and IBM i 7.3 TR8, IT Jungle caught up to Scott Forstie, a senior technical staff member at IBM’s lab in Rochester, Minnesota, and the database architect for Db2 for i.

  There’s …

  Read more

• Guru: A Simple, Effective Way To Compare Data Using SQL

  April 20, 2020 Ted Holt

  One thing I have learned over the years is that no matter how much technology changes, people always ask the same questions like: “Why does the computer say we have 50 widgets when we only have 45?” and “Can you tell me who changed the due date of order number 12345?” and “How do sales of widgets this year compare to the same time last year?” It is the last of these that I wish to address today.

  Comparing data is a very common activity. Everybody compares data: sales people, production people, purchasing people, and of course management people. This …

  Read more

• Here’s What’s In the Latest IBM i Technology Refreshes

  April 15, 2020 Alex Woodie

  As expected, IBM today officially unveiled its spring Technology Refreshes for IBM i. Among the goodies that will become available for IBM i 7.4 TR2 or IBM i 7.3 TR8 (or both) are enhancements to Db2 Mirror, a new approach to tape library virtualization, improvements to open source, and new features and functionality around Db2, RPG, RDi, and security, too.

  Months ago, IBM execs circled April 14 on their calendars as the day for the big IBM 7.4 TR2 and IBM i 7.3 TR8 reveal, with the idea that the following week’s POWERUp conference in Atlanta, Georgia (now canceled, but …

  Read more

• Guru: Copy From Stream File FMTOPT(*NOCHK)

  April 13, 2020 Bob Cozzi

  Using SQL frequently, as I do, I tend to look for solutions to problems that can be resolved using the database language (i.e., SQL). Sometimes I have to invent a missing piece of the puzzle. Often that entails writing a User-Defined Function (UDF) for use in SQL, but sometimes a CL command is the better choice.

  Recently I had a situation where what the client calls an “EDI File” was being downloaded using sftp on the IBM server running i. This file is created at a vendor that runs IBM mainframes (an actual mainframe by the way) and the file …

  Read more

• Guru: SQL Checks For Control Breaks

  April 6, 2020 Ted Holt

  A control break occurs when the combined value of one or more fields changes from one row (record) to the next when reading a data set sequentially. I used to write RPG programs with control breaks often. Now that reports are less common, I write them less often, but that’s not to say I never write a program with control breaks.

  When I first learned to handle control breaks in RPG, I used the L1 through L9 level indicators. These worked wonderfully and fed my family for several years. When I moved from the System/36 world to the S/38 (and …

  Read more

• Guru: SQL Can Generate A Series

  March 16, 2020 Ted Holt

  Most of my work is run-of-the-mill, same-old-same-old, more-of-the-same. I’m not complaining. Most of life is mundane and routine, and that’s as it should be. Too much icing ruins the cake. But sometimes I get a challenge, and when that happens, programming can be fun.

  Today’s article comes out of such an experience. I needed a table with a week’s worth of dates in it. I could have written an RPG program, but I knew that SQL could handle the task. Today I’ll show you a couple of methods that you can use to generate a series of whole numbers and …

  Read more

Previous Articles Next Articles