If you are an SQL user, you need to get your hands on 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. I want to take you through some of the highlights of the database functions of IBM i Access Client Solutions.

Some Background

Over the last few years, trying to find the right tools for the SQL developer has been quite a challenge. There were Run SQL Scripts in System i Navigator, the

SQL PL has four looping structures. The most useful one, to my way of thinking, is the FOR structure. It is different from–and more powerful than–the RPG FOR op code, and it’s easy to learn and use. Here’s how it works.

FOR iterates over a read-only result set and terminates when there are no more rows to process. Think of a FOR loop as a read-only cursor without the messiness of OPEN, FETCH, and CLOSE. Let me illustrate with a stored procedure.

create or replace Procedure Billing (in p_BillingCycle dec(3))
for One_Customer as
   select c.AccountNumber
     from customers as c 
    where 

In Why Node.js? we discussed Node.js and how to get up to speed with “hello world” from a program, the Node.js REPL (Read, Eval, Print, and Loop), and a web application. Now we will build on that knowledge by actually creating an application to show your team.

A gent by the name of Rainer Ross recently posted a link to the IBM i Professionals LinkedIn group declaring the benefits of the new Webix framework. (Webix.com is freemium software. There are free versions and paid versions. Please adhere to the licensing.) Because of my comments on his post I received an