Insert from Examples is greatly enhanced.

Available from the edit menu, context menu or shortcut key. A quick way of commenting/un-commenting a number of lines. This option can be disabled/enabled from the view menu. The items we are interested in are in the Database section: Run SQL Scripts and SQL Performance Center.Īt first glance, Run SQL Scripts bears a striking resemblance to what we are used to, as shown in Figure 2.īut when we start to use Run SQL Scripts, as shown in Figure 3, we see our first major difference: the code is color-coded!Īs well as the color coding, there are a few other enhancements, some of which we will look at in more detail in a moment: 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. Run SQL Scripts can be activated from within RDi.I cannot tell you how happy that makes this Mac user! The main benefits of ACS, from the database developer’s point of view, are: 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

Ibm i access client solutions netserver