Suppose I have four tables that I commonly join. Is there any benefit to adding redundant criteria to the join? Or to the “where” clause? That is, will redundant criteria or selection expressions improve performance?

–Philip

Philip’s four tables are keyed as follows:

SITE     ITEM      PROCESS   STRUCTURE
------   ------    --------  ---------
SiteID   SiteID    SiteID    SiteID
         ItemID    ItemID    ItemID
         Revision  Revision  Revision
                             StructID

Here’s a join without redundant join criteria:

select whatever
from site as s
join item as i 
  on s.siteid = i.siteid
join process as p
  on i.siteid = p.siteid
 and i.itemid = p.itemid
 and i.rev    = p.rev
join 

An old joke says, “How do you know a salesman (or politician) is lying to you?” The answer: “His lips are moving.” All joking aside, your RPG IV F specs can lie to you, and it’s not obvious when they do. This is not a serious problem, but I’ve run across it on occasion and want to be sure others are aware of it.

Let’s say the following program is running:

H dftactgrp(*no) actgrp('QILE')
Fcustcdt   uf   e             disk
Ferd01p    o    e             printer
 /free
     *inlr = *on;
     dow '1';
        read cusrec;
        if %eof();  
            leave;
        endif;
        write erd01p1;
     enddo;
     return;

This is

I’m having problems connecting to different Hardware Management Consoles (HMCs) via a single Web Based System Manager (WebSM). I can connect to our production HMC, but I am having problems accessing our backup HMC in New York. I enter an IP address for the backup HMC, but it’s not accepting my user ID and password. Is it possible to access two HMCs with the same WebSM?

–Ray

Hi Ray,

Yes, it is possible to access two different HMCs through the same WebSM configuration. I do it in my shop where I use one WebSM to access three different HMCs on