• More Open Source Databases Coming To IBM i

  June 15, 2020 Alex Woodie

  IBM is in the process of bringing several new open source databases to the IBM i platform, including schema-less NoSQL databases as well traditional relational systems. Among the databases that Rochester is targeting are MongoDB, arguably the most popular NoSQL database and a favorite among Web and mobile developers, as well as PostgreSQL, one of the industry’s oldest and most widely used relational databases.

  Databases today almost are like programming languages, with developers mixing and matching databases to handle different functions, often within the same application. DB-Engines.com tracks more than 330 distinct databases, while there are somewhere around 700 programming …

  Read more

• Guru: Graphical Debugging Through ACS

  June 8, 2020 Ted Holt

  ACS (IBM i Access Client Solutions) keeps getting better and better. I can’t stay up-to-date with the latest releases of all the software I use, but I do everything I can to keep up-to-date with ACS. One of the handiest of the relatively most recent releases is the ability to access IBM i Debugger through Run SQL Scripts. If you haven’t tried IBM i Debugger, you’re missing out.

  IBM i Debugger (a.k.a. System Debugger) is part of the IBM Toolkit for Java. It’s graphical, and it makes the green-screen debugger (STRDBG) look like something built by cavemen. To show you …

  Read more

• imPower Technologies Embraces Switch to Online Learning

  April 8, 2020 Alex Woodie

  Traditional schools around the world are in turmoil as a result of the COVID-19 lockdown and the sudden switch to online learning. For Jim Buck and his new IBM i training venture, imPower Technologies, the sudden popularity of virtual education validates the work he and his colleagues have done to build an Internet-based IBM i education operation.

  “We’ve been preparing for this unknowingly for years now,” imPower Technologies Chief Operating Officer Michelle Lyons says. “Had we known, we couldn’t have prepared better.”

  Buck and Lyons started building imPower Technologies nearly three years ago to provide an online vehicle to deliver …

  Read more

• Guru: Calling RPG Programs From Python, Part 1

  March 30, 2020 Mike Larsen

  In a prior article, I showed how to pass parameters to a Python script and execute the script from an RPG program. Based on feedback and my own curiosity, I wanted to see how I could pass parameters to an RPG program and call it from Python. After a bit of research, I found the Python interface itoolkit.

  itoolkit is an open source project provided by IBM as an interface to the XMLSERVICE toolkit, which allows us to call RPG programs, service programs, CL programs, and PASE Shell commands. itoolkit can be installed using an SSH terminal with …

  Read more

• Guru: ACS 1.1.8.3 Content Assist Includes Prompt For SQL!

  February 10, 2020 Birgitta Hauser

  STRSQL, the green-screen facility for executing SQL Statements, has had its days. Nevertheless, many SQL users still prefer this legacy interface over the Access Client Solutions (ACS) Run SQL Scripts facility. Others use third-party tools to execute SQL statements. The common excuse has been that the Run SQL Script facility does not include a way to prompt SQL commands, tables, and columns. In ACS version 1.1.8.3, Content Assist includes prompting for SQL statements.

  Before ACS Version 1.1.8.3, no prompting was available within the Run SQL Scripts Facility. To access tables, views or materialized query tables (MQTs), we needed to know …

  Read more

• Latest TRs For IBM i Now Available

  November 20, 2019 Alex Woodie

  IBM last week delivered the latest IBM i operating system Technology Refreshes, giving good IBM i boys and girls around the world early Christmas presents in areas like programing, operations, database, and security. Here’s a quick recap of the new stuff in IBM i 7.4 TR1 and 7.3 TR7.

  There were several general enhancements with IBM i 7.4 TR1 and 7.3 TR7. For starters, administrators gained more control over resources available to the Integrated Web Server (the one powered by Apache) with the new capability to install it the Web server in a user-specified sub-system. Admins also get new functions …

  Read more

• Revenge Of The Zombie Green Screen

  October 30, 2019 Alex Woodie

  Don’t look now, but command line interfaces – which were supposed to have been killed off years ago at the hands of superior graphical user interfaces (GUIs) – are making a comeback in the general IT scene. And the command line love appears to be spilling over into the IBM i.

  Command line interfaces, or CLIs, never completely disappeared from the scene. Even Windows 10 users can summon the dark magic of the DOS prompt with a few tactical clicks of the keyboard, mouse, or (God forbid) touchscreen. But like crazy uncles and credit card debt, the CLI has largely …

  Read more

• Digging Into the Latest IBM i TRs

  October 23, 2019 Alex Woodie

  The fall batch of Technology Refreshes (TRs) have been revealed, and as expected, there’s a bit of new functionality available for customers who use IBM i 7.3 and 7.4. In this story, we’ll tackle enhancements in open source, systems management and monitoring, and development, which means we’ll dive deeper into other areas, like database and HA/DR, in a future story.

  Let’s start with the fun stuff: open source. With IBM i 7.3 TR7 and 7.4 TR1, IBM has brought support for two prominent open source projects, including ZeroMQ and Redis.

  ZeroMQ is a universal messaging library that allows users to …

  Read more

• Java License Fallout Continues Impacting IBM i Shops

  October 23, 2019 Alex Woodie

  Oracle’s decision to restrict the previously free distribution of Java version 8 tools and runtimes is impacting the entire IT industry. In our little neck of the woods, the decision to charge businesses for using Oracle’s Java has forced IBM i shops to take a hard look at the technology platform, and in some cases look for alternative solutions.

  Oracle ruffled feathers in the Java community in 2017, when it made substantial changes to its Java roadmap. The company announced that Java Standard Edition (SE) version 8, which is a legacy version of Java but is still in widespread use, …

  Read more

• Guru: Move Objects with Access Client Solutions

  October 14, 2019 Dawn May

  Sending objects from one IBM i partition to another is a common task. Access Client Solutions’ IFS task makes it simple to copy or send objects. The IFS task was introduced in ACS in July 2016, so this is not a new development, but it may not be widely known.

  Perhaps you need to send a save file to another IBM i partition. There are several ways to do this. FTP and Secure FTP are often used, but using FTP to transfer IBM i objects involves all sorts of complications. The IBM i Knowledge Center dedicates an entire section on …

  Read more

Previous Articles