• IBM Improves Run SQL Scripts with ACS Update

  September 22, 2021 Alex Woodie

  In recent years, Access Client Solutions (ACS) has become an indispensable utility for a range of tasks involving the IBM i. A good reason for that success is the adoption of Run SQL Scripts, which has been enhanced with the latest Technology Refresh for IBM i 7.3 and 7.4.

  ACS is a Java-based product that IBM first unveiled in 2012 and that has replaced other versions of Client Access, including the dedicated Windows utility. No matter what type of computer or device you’re using to work with the IBM i server, be it Windows, Linux, or Mac, you can access …

  Read more

• IBM i Open Source Gets Better With Fall 2021 TRs

  September 20, 2021 Alex Woodie

  The open source community has become a big source of new software for the IBM i platform in recent years, if not the biggest contributor. To that end, the recent Technology Refreshes (TRs) for IBM i 7.3 and 7.4 bring a dozen or so new or updated packages to the platform.

  One of the most exciting additions to IBM i’s open source repertoire is tn5250, a bare-bones terminal emulator for accessing IBM i system and application screens. Distributed via Source Forge, tn5250 is a Windows program that enables users to access green screens from the Secure Shell (SSH) terminal. …

  Read more

• The IBM i Job Environment, It’s a Changin’

  September 15, 2021 Alex Woodie

  The IBM i job market ain’t what it used to be. Change is a constant in this world, but the rate of professional change during the current pandemic is of particular interest at the moment. From new technologies and enlarging salary requirements to work-from-home and pending retirements, you could say we’re experiencing a period of punctuated equilibrium when it comes to working in the IBM i ecosystem.

  Since the start of the COVID-19 pandemic, companies across many industries have adopted work-from-home mandates. IBM i shops, like all others who can, have moved strongly in that direction. Many have still not …

  Read more

• New Nav Puts SQL Services Within Reach

  September 15, 2021 Alex Woodie

  IBM delivered new Technology Refreshes (TRs) for IBM i 7.3 and 7.4 last week, and there’s a lot of good stuff in there. Arguably one of the biggest announcements is the overhaul of IBM i Navigator, which the folks at IBM have taken to calling “New Nav.” But what makes New Nav so special?

  IBM rewrote New Nav from the ground up in Angular, a JavaScript framework for building Web and mobile applications, and PrimeNG, a popular component library for Angular. The combination of these two technologies gives New Nav a fresh-looking interface that will appeal to users of all …

  Read more

• Surprise! It’s IBM i Technology Refresh Time

  September 13, 2021 Alex Woodie

  IBM surprised the midrange world last week by announcing Technology Refreshes (TRs) for IBM i 7.3 and 7.4, which became generally available on Friday. The fall TRs, which typically are announced in October, brought support for the new Power10-based Power E1080 server in addition to a slew of enhancements to the operating system and surrounding IBM i products.

  The big piece of news with the new TRs – IBM i TR 7.3 TR11 and 7.4 TR5 – is support for servers based on IBM’s speedy new Power10 processor, which is the first Power chip based on its 7 nanometer …

  Read more

• Guru: Another Red Flag – Joining On Expressions

  August 30, 2021 Ted Holt

  One would think that a given datum, for example a sales order number, would be defined identically in the various database tables in which it is found within an organization, but one might be wrong. I have on many occasions faced the challenge of joining two or more tables on unmatched data types.

  But it gets worse than that. Sometimes joins involve expressions, which may consist of mathematical operations and/or invocations of functions, both intrinsic and user-written. As with the word DISTINCT in a SELECT, the presence of expression in a join sends up a little red flag that …

  Read more

• Guru: Set Beats A Loop

  August 23, 2021 Ted Holt

  Hey, Ted:

  I’m sending you some RPG source code that I put into one of our inquiry programs and would like to have your insight. Instead of using the SETLL, DOW and READE opcodes to loop through a group of selected records, I used the SQL SET statement. This seems to me much easier for someone else to understand and follow. Is this good practice?

  — Mike

  I was glad to see Mike’s email in my inbox, as always. He and I met in person at the RPG & DB2 Summit a few years ago, and I’ve enjoyed getting to …

  Read more

• Calling All IBM i Platforms. . .

  August 16, 2021 Daniel Magid

  In a microservices world, all elements of what used to be monolithic application programs are now chunks of code linked to each other using any number of application programming interfaces, or APIs. Those APIs can be based on a remote procedure call, or RPC, architecture, which is a kind of generic distributed client/server approach, or the REST – short for representational state transfer – architecture favored by parts of the commercial Web software stack that has dramatically grown in popularity in the past two decades. Either way – and in fact, there are more than two ways – APIs are …

  Read more

• Guru: Odds and Ends

  August 16, 2021 Ted Holt

  I really appreciate the comments that readers add to the end of articles or send to me in email. The more you share, the more all of us are better off. I know that you don’t have time to go back through articles we have published to see if anyone has commented, so this week I do that for you. Please keep the feedback coming!

  Several people posted responses to Paul Tuohy’s article Getting Meaningful Audit Information from a Journal. You can read them for yourself, but I wanted to thank Emanuele, who mentioned a tool that is similar …

  Read more

• Guru: Elapsed Time For Human Beings

  August 2, 2021 Ted Holt

  Quick! Think of a weird animal! Perhaps you thought of the platypus, a duck-billed mammal that lays eggs. Maybe Dr. Doolittle’s pushmi-pullyu jumped to mind. Maybe you thought of a politician or a musician or your next-door neighbor. I know a weird animal that you probably didn’t think of.

  The weird animal I have in mind is called the duration. This animal is found in SQL queries. There are three species: timestamp, date, and time. Today I write about the challenges of interacting with this strange entity. I’ll use the timestamp duration as an example. Interacting with date …

  Read more

Previous Articles Next Articles