• Don’t Be A Blowhard

  March 22, 2021 Timothy Prickett Morgan

  One of the things that made the AS/400 a great system, as well as the System/36 and the System/32 and System/34 before it, was that there were entry machines that had enough oomph to support the data processing and storage needs of small businesses within a reasonable budget and in a system that didn’t need a datacenter or even a data closet. They could be tucked under a desk, or left to run beside them.

  Way back in the dawn of time, there were special machines, even smaller than the original AS/400-B10 and AS/400 -B20, that were even smaller and …

  Read more

• The Prickly Pear Of Auto ID For IBM i

  December 16, 2020 Timothy Prickett Morgan

  Good companies can batten down the hatches and pilot their enterprise through rough economic waters, but great companies identify opportunities and successfully pursue them whether or not times are good or bad. It takes a bit of pliability to be adaptable enough to not just accept change, but to embrace it, and also to be certain enough of your company and its customers to build a core user base and just serve those customers relentlessly with steady improvements. This is a tough balancing act, but if you look at the case studies, you find this balance is what gives companies …

  Read more

• You’re Only As Old As The Applications You Feel

  June 24, 2020 Timothy Prickett Morgan

  You didn’t actually think that we would have forgotten that Sunday, June 21^st, was the 32^nd birthday of the Application System/400, did you? Of course we didn’t forget.

  It was also Father’s Day and the first day of summer, and to be perfectly frank (Soltis), I got a new smoker from my wife and I spent the afternoon learning about the joys of hickory smoked barbeque ribs. It is a gift that just keeps giving, because I made about 40 pounds of meat in various kinds and flavors because I needed to try everything all at once. …

  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

• The Distinguished Professionals Of IBM i

  February 17, 2020 Timothy Prickett Morgan

  We use the term legacy a lot in the IBM midrange and mainframe markets, and not necessarily in the good way we talk about political leaders or business executives or sports stars all leaving a legacy behind of their body of work. I use the term when it means something precise – legacy applications, for instance, are the ones that originated back in time and that have not been modernized in any substantial way because perhaps they don’t need to be.

  I prefer the term vintage when I am talking about hardware and software releases because that conveys a …

  Read more

• Sometimes Even DIYers Need A Little Help

  October 7, 2019 Timothy Prickett Morgan

  If there ever was a crowd that liked to do it themselves, it is the IBM midrange. Well, probably more like half to two-thirds of the IBM midrange. But you know what I mean.

  These companies started programming way back in the 1970s with one of Big Blue’s System/3 or System 32, or System/34 machines, and moved on to the System/38 or the System/36. The former launched in 1978, a decade after the System/3 that started it all in Rochester, Minnesota, and the latter came out in 1983, five years before the AS/400. The machines had sophisticated batch and interactive …

  Read more

• Automation For The Masses – Here Come The Bots

  October 7, 2019 Richard Schoen

  Have you ever heard of using a robot to assist in completing your daily work? Or maybe the concept of eliminating redundant manual data entry and re-keying of info you didn’t think was possible? Let’s talk about bots, as these software robots are known, and how they are coming to an IBM i shop near you and how your IT and business teams can leverage this technology to get work done more efficiently.

  Many people in the IBM i world have never heard of the acronym: RPA. RPA stands for Robotic Process Automation, the current buzz word for implementing software …

  Read more

• Guru: Read a Data Area As a One-Row Table with SQL, Take Two

  August 26, 2019 Ted Holt

  Fifteen years ago, reader W.G. asked me about the possibility of treating a data area as a one-row table (a physical file with one record) in an SQL query. The question intrigued me because in my System/36 days, I had often wished that I could access the local data area (LDA) as a one-record data file in a query.

  Today, thanks to Scott Forstie and his team at IBM, I update my response to W.G. with more information. It’s not that the technique I presented in 2004 is outdated — it’s as relevant as ever — but that the fine …

  Read more

• Guru: When %SCAN Isn’t Sufficient

  June 24, 2019 Ted Holt

  The RPG %SCAN built-in function is wonderful! I can still remember having to look for a string within a string using RPG II on System/36. What an ordeal that was! Yet in some situations %SCAN can’t do all I need it to do. In those cases, I rely on the power of SQL.

  One case where SQL comes in handy is when I need a case-insensitive scan. Instead of RPG’s %SCAN function, I use SQL’s LOCATE and UPPER functions, like this:

  dcl-s  Description  char(48);
  dcl-s  pos          int (10);
  
  exec sql
     set :pos = locate ('HAMMER', upper(:Description));
  

  If Description has the …

  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

Previous Articles Next Articles