I hope 2013 was a good year for you. It was my best year in a while. I left a dysfunctional bureaucracy for a company where I can make a difference. I renewed several old acquaintances. And I found out from LinkedIn that I know someone who knows someone who knows Haynes Brooke, the guy who plays the sun in the Jimmy Dean sausage commercials. Let’s close out the year with some of the feedback you’ve been kind enough to send to me.

Hey, Ted:

In Alan’s Easy Method For Building A CSV File From A Report, you

Consider the following summary query:

select d.ItemNumber,
       sum(d.Quantity) as Qty,
       sum(d.Quantity * d.Price) as Extended
  from InvoiceLines as d
 group by d.ItemNumber
 order by 1

Here’s the result set:

ITEMNUMBER      QTY      EXTENDED
  A-1             8         88.00
  A-3             7         35.00
  A-7             7         52.00
  B-1            26         51.25
  Z-3             2         18.00

Standard stuff, yet very powerful. It beats writing an RPG program to read a file, check

I’m currently working with a client to migrate three IBM i partitions to new Power 7+ machines located in two data centers in different states. While there are several ways to approach migration, over the next two issues I’ll discuss four specific techniques for moving an IBM i partition to a new location and the different tasks you have to perform for each technique.

Four Ways To Move An IBM i

In general, there are four techniques for moving an IBM i partition to a different machine:

1. Restore the partition in place or to a new location using the same