The basis for this article comes from a brief conversation I had over coffee, while recently presenting an Introduction to SQL course. It went along these lines:

Tom: “In Run SQL Scripts, how can I get a list of the fields in a file?”

Me: “You mean the columns in a table or view.”

Tom: “OK. In Run SQL Scripts, how can I get a list of the columns in a table or a view?”

Me: “Just do a SELECT * and the column names are shown at the top of the columns.”

Tom: “Nope. I took the option to

In George Orwell’s novel Animal Farm, all animals were declared to be equal. However, that was not the case. By the end of the book, some were “more equal than others.” You might think that all joins are equal, but you would be wrong. Unequal joins have their applications, too.

The equijoin is the norm in business. A customer number in a table (file) of invoices matches (equals) a customer number in a customer master table. But it is also possible to join on non-matching conditions such as not equal, greater than, less than, greater than or equal to,

Two years ago, I wrote an article on how to start planning for an IBM Power i upgrade a year in advance. In that piece, I covered business partner evaluation, extended maintenance, third-party software, and budgeting for performance. Today I’m revisiting the topic and adding other hardware upgrade issues that require longer term planning and may need almost a year to complete.

A Lot Of Ground To Cover

In no particular order, here are the Power i hardware upgrade items that you can start planning for a year in advance of a hardware upgrade.

1. Business partner evaluation–Evaluating your relationship