Once you have defined one or more connections, you can select the system you are connecting to from the drop-down box above the menu.įigure 1: Starting IBM i Access Client Solutions. You define connections to systems using System Configurations in the Management section. When you start ACS, you are presented with a window as shown in Figure 1.
#Ibm i access client solutions data transfer duplicate key full
Although ACS does not (yet) offer the full range of what was available in System i Navigator, it does offer a few benefits over what was there. Then along came IBM i Access Client Solutions (ACS). Unfortunately, IBM did not announce support for System i Navigator in Windows 10. Without a doubt, the most useful of these tools was Run SQL Scripts in System i Navigator, if for no other reason than these were the only tools to provide access to Visual Explain. The chances are you have used a permutation and combination of a few of these tools. There were Run SQL Scripts in System i Navigator, the DDL wizards in System i Navigator and Navigator for i, the Database Maintenance and Plan Cache functionality in System i Navigator and Navigator for i, the Database Perspective in RDi, Data Studio, Start SQL (STRSQL) on green screen, and any open source database interface such as SQuirrelSQL.
Over the last few years, trying to find the right tools for the SQL developer has been quite a challenge. I want to take you through some of the highlights of the database functions of IBM i Access Client Solutions. After some false starts, it looks as if IBM is heading in the right direction again when it comes to providing tools to help us develop and use SQL. If you are an SQL user, you need to get your hands on IBM i Access Client Solutions.
IBM i Access Client Solutions For Database