• Guru: SQL Writes CL

  November 30, 2020 Ted Holt

  SQL is the one tool I cannot work without. Take it away from me and I’ll start driving a truck for a living. Naturally I’m eager to find more ways to make SQL work for me. Today I’d like to share how I recently used SQL to write a huge CL command for me. This is a technique that’s good to know.

  My challenge was to copy all of the several hundred physical data files in a library to a save file so that those files could be loaded onto another IBM i system. The Save Library (SAVLIB) command was …

  Read more

• Trinity Guard Unveils New Tools for Linux, Db2 for i

  November 18, 2020 Alex Woodie

  Trinity Guard is on the move. The Houston, Texas, based security software company, which is the spiritual successor to the PentaSafe products, is rolling out a full auditing solution for Linux. It’s also developing a Linux version of its security management tool, TGCentral, with an AIX version up next. Plus it’s months away from releasing an encryption solution for Db2 for i.

  2020 has not been easy for anyone, but it’s not stopping the folks at Trinity Guard from moving forward on its roadmap items. Near the top of that list is increased support for running on Linux, which has …

  Read more

• Db2 And SQL Services Get Upgrades With TRs

  October 12, 2020 Alex Woodie

  Among the biggest enhancements that IBM is bringing to IBM i with the latest batch of Technology Refreshes are new capabilities added to the integrated Db2 database and, specifically, the slew of SQL-based services that retrieve all types of data from the platform for IBM i professionals.

  As we previously told you, IBM has decided to rename SQL Services, which were the collection of pre-defined SQL queries that recreate traditional IBM i commands and sometimes bring something entirely new. The growing gaggle of services (or perhaps it’s a herd?) are now being officially referred to as IBM i services, …

  Read more

• How The Latest TRs Bolster The Core IBM i OS

  October 7, 2020 Alex Woodie

  Yesterday was Technology Refresh (TR) day for IBM and its IBM i operating system, and Big Blue didn’t disappoint. The company unveiled new releases of IBM i 7.4 and 7.3 that bring a slew of new capabilities to the core operating system as well as surrounding offerings like Db2 Mirror, ACS, and RDi. In this article, we’ll look at enhancements to the core OS and related key features.

  During a COMMON webcast Tuesday, IBM i Chief Architect Steve Will touched broadly on a number of enhancements that soon will be available in the TRs. Most of the new capabilities will …

  Read more

• The Fall Technology Refreshes Are Almost Here

  October 5, 2020 Timothy Prickett Morgan

  There has been a spring-fall rhythm to the cadence of software updates for along time, but the creation of the OpenStack cloud controller by NASA and Rackspace Hosting really snapped the commercial Linux distros into an April and October cycle of commercial rollups. And so, after many years of Technology Refreshes that follow the same rhythm, we come to expect updates to IBM i about now.

  And starting tomorrow, IBM will be rolling out the fall Technology Refreshes for the current releases. That would be IBM i 7.3 TR9 and IBM i 7.4 TR3. And these, unlike those partial Technology …

  Read more

• Guru: DISTINCT Can Hide A Performance Problem

  September 28, 2020 Ted Holt

  When I see the word DISTINCT in an SQL query, a little red flag goes up inside my head. Not literally, of course. But it does make me pause and scrutinize the query more closely. I have found that poorly designed queries sometimes include the word DISTINCT as a final act of redemption to forcibly return the proper result set.

  The purpose of DISTINCT is to remove duplicate rows from a result set. As the DB2 for i SQL reference puts it:

  The keyword DISTINCT is not considered an argument of the function, but rather a specification of an operation …

  Read more

• Is It Time To Rename RPG?

  August 24, 2020 Alex Woodie

  Should IBM rename RPG, and if so, what should the new name be? It’s an interesting idea, and one that was recently floated by a member of the IBM i community, who submitted an official request for enhancement (RFE) on the matter. The crux of the argument is that full free-format RPG is such a dramatic departure from fixed-format RPG that it deserves a new name. But will IBM, which owns the language, go along with the change?

  Report Program Generator, or RPG, debuted way back in 1959, at the dawn of the computer age, as a way to replicate …

  Read more

• Raz-Lee Simulates Ransomware Attack on IBM i

  August 12, 2020 Alex Woodie

  How would your IBM i server react to a ransomware attack? Would it successfully repel the invaders, or would it give the bad guys what they’re after: chaos and bitcoin? Simulating a ransomware attack is the gist of a new feature in Anti-Ransomware from Raz-Lee Security, which recently shipped a new release of the software.

  Raz-Lee Security debuted Anti-Ransomware back in 2018, a year after a pair of widespread ransomware attacks (WannaCry and Petya) made the computing world sit up and take notice of the new security threat blossoming on the Internet.

  Anti-Ransomware uses a rules-based approach to detect …

  Read more

• IBM Rolls Out ACS 1.1.8.5

  August 12, 2020 Alex Woodie

  IBM last week introduced a new release of Access Client Solutions (ACS), the popular IBM i client that’s used by administrators, programmers, and engineers alike. There are enhancements to Run SQL Scripts, new 5250 viewing options, and a performance boost for viewing selected files on the IFS with version 1.1.8.5, among other mostly minor updates.

  According to the release notes associated with the new iteration of ACS, IBM made a handful of changes with version 1.1.8.5.

  Let’s start with the improvements to Run SQL Scripts, which is an increasingly popular utility in ACS that leverages the power of SQL and …

  Read more

• ARCAD Generates APIs From 5250 Screens

  July 22, 2020 Alex Woodie

  Many IBM i shops want to modernize their 5250 applications by developing REST-based Web services and API extensions, but they face difficulties getting started. These organizations may want to check out ARCAD Software’s latest offering, ARCAD API, which takes much of the pain and complexity out of the API generation process.

  REST-based APIs have become a standard method for exposing data and business logic to the outside world. There’s an abundance of ways that APIs can be used–pushing data to Web or mobile users, for example, or pulling data from a cloud-based CRM system. Just about any higher-level application function, …

  Read more

Previous Articles