To do a quick review of my previous article, UNION is very useful when an SQL statement or query must operate on two or more tables and JOIN cannot be used to produce the desired result set table. For example, if you have multiple history tables–one for each specific time period (year, month, week, etc.), and their record formats are similar and compatible, a union is a good way to query and combine two or more of these tables to derive a single, final result set table using SQL.

Several months ago, a friend sent me the spreadsheet shown

Most i programmers have a library of RPG or COBOL utilities they’ve written or filched from another source. Having a library of samples and pre-built code is a great productivity booster. However, have you ever considered adding C and C++ code to your library? You don’t know C? Big deal. If you have the C compiler loaded on your i, there’s an abundance of C and C++ code out there on the internet just waiting for you to discover. Plus, if you’re well versed in ILE concepts, you may be further along the C path than you think.

Consider this

I wanted to pass this IBM email along about HMC V7 HMC compatibility with Internet Explorer 8 (IE), in case you hadn’t seen it. Evidently there are some problems trying to remotely access HMC V7 with IE 8.

–Terrence

If you’re running HMC V7 (including the new v7.7.1 software), IBM is currently passing around a note that clarifies Big Blue’s position on support for Internet Explorer 8 (IE) compatibility with Hardware Management Console (HMC) v7.x.x and higher. Here’s what IBM has to say about this issue and what you can try to do to fix it.

When IBM released