By now you have probably heard that with the latest V7 changes to RPG IV, we can code completely free-form programs. But why should you care? Maybe you saw the benefit of free-form calcs and have been using them for some time, but you still can’t see why you should bother with learning this new way of coding D, F, and P specs. What’s the point? Well, I’m going to share my thoughts on that subject.

On my last birthday, I officially became a geezer (i.e., senior citizen if we want to be polite), so with some 45-plus years of

IBM i 7.1 and its various incremental releases have introduced many great new features in DB2 for i. Many of the features have been covered in Four Hundred Guru tips. This tip will cover some of the less exciting, yet important features that may have gone unnoticed. Best of all, many of them are even available in IBM i 6.1.

Specify System PROGRAM NAME Keyword When Creating An SQL Trigger To Prevent Naming Conflicts For System Names

Consider the following CREATE TRIGGER statement that features a long SQL name:

CREATE OR REPLACE TRIGGER ADVWORKS08.UpdateSalesOrderHeaderModifedDate
AFTER UPDATE ON ADVWORKS08.SalesOrderDetail
REFERENCING NEW_TABLE 

IBM first introduced Power 7 servers running IBM i on February 8, 2010. So if you leased one of those machines, chances are good that it’s either coming off lease soon or about to come off lease. If you’re ready to say goodbye to an old Power i, here’s seven things to do before you return that old machine to the leasing company.

The Big Seven

There are seven things you need to do before you can return an end-of-lease machine to a leasing company.

1. Replace it.
2. End the lease.
3. End extended maintenance (if relevant).
4. Inventory the machine.
5. Wipe or