• 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

• IBM i PTF Guide, Volume 22, Number 32

  August 12, 2020 Doug Bidwell

  It is another busy week here in the summer of 2020, there is a lot of activity among our IBM i customers, and this is a blessing indeed. Better to be too busy than not busy enough.

  In the interest of time, we will get right to the point. This week there is a new release of Access Client Solutions: 1.1.8.5. There is also new release of SPT (System Planning Tool): V211.

  Here’s the PTF rundown by release:

  PTF Groups 7.4:

  • Temporary Storage PTFs

  PTF Groups 7.3:

  • Temporary Storage PTFs

  PTF Groups 7.2:

  • Temporary Storage PTFs

  PTF Groups 7.1:

  • Nothing

  …

  Read more

• Guru: Creating PDF Documents With Python

  July 27, 2020 Mike Larsen

  I’m often asked to create reports for my business partners. The format of the report depends on who made the request. If the financial team made the request, I may produce an Excel file. The CEO may want to report quarterly sales to their shareholders. In that case, I may produce a PDF using the company letterhead.

  In a prior article, I showed how to create Excel files using Db2 tables. Now I’m going to show how to create PDF documents using Db2 tables.

  This story contains code, which you can download here.

  I always start by making …

  Read more

• 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

Previous Articles