• Hit A Fiduciary Home Run With A Backup, DR, Cybersecurity Triple Play

  October 4, 2021 Jim Kandrac

  The old adage that the only secure computer is one that is not networked to anything has never been more true; however, it is also irrelevant even if it is funny. No computer can exist in a vacuum and is only useful if it is connected to other machines – and potentially lots of other machines. The level of malicious activity out there on the networks of the world has never been higher, and you had better get used to the idea that the situation is going to get worse every year, and the IBM i platform is absolutely …

  Read more

• Db2 PTF Group Enhancements Target Web Services, Audit Journal

  October 4, 2021 Alex Woodie

  It is indisputable that the Db2 for i database is the beating heart of the IBM i platform. There were no earthshattering enhancements to this database in the latest batch of Technology Refreshes for IBM i 7.3 and 7.4 that IBM announced and shipped last month. But there were a few items worth mentioning that shipped in the Db2 PTF Group, including new HTTP commands for calling the database via REST and new SQL-based commands for querying the security audit journal.

  The top new Db2 for i feature arguably is the new set of functions for HTTP requests to consume …

  Read more

• Fresche Takes On New RPG Development And Modernization With X-Elevate

  September 27, 2021 Timothy Prickett Morgan

  Over the years, Fresche Solutions, the IBM i conglomerate that is focused on development of new applications as well as modernization of existing applications, their interfaces, and their databases, has acquired and built tools that help programmers create Java and PHP programs, or convert RPG applications to Java and PHP. But by its own admission, Fresche did not focus on new RPG application development or the kind of incremental programming that a lot of IBM i shops are doing to gradually modernize their applications, usually through the shift from fixed format RPG to the free form RPG that is similar …

  Read more

• Guru: Alternate SQL Row-Selection Criteria Revisited Revisited

  September 27, 2021 Ted Holt

  I am not a “do as I say and not as I do” kind of person. After I wrote the article Guru: Alternate SQL Row-Selection Criteria Revisited, I got serious about using dynamic SQL in my RPG programs instead of enabling and disabling logical expressions in the WHERE clause. I’m reliving the days when OPNQRYF was my best friend, trying to make apostrophes play nice with string concatenation.

  Overall, I’m happy with the change. When I have converted the switch-laden version to dynamic SQL, I have seen a noticeable performance improvement in some cases, and at least a slight …

  Read more

• 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

Previous Articles Next Articles