Access Client Solutions Archives

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: 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

Content archive

Recent Posts

Subscribe

Pages

Search