In an earlier tip, I provided a peek at the DDS Designer integrated with RSE in the Rational Developer for Power Systems (a.k.a., RD Power). In this tip, I’m going to go into a few features that may not be easy to spot at first glance. But some of these things are among my favorite features of the tool.

In the last tip, I talked about how to easily see and edit the DDS source using the Source tab under the Design view. If you just want to have a peek at the source for a particular item

I am studying your tip Updating through a Join with SQL, and something escapes me. I do not understand the redundancy in the first code example. Do all updates that involve joins have to have redundant code?

–Ron

I know it’s confusing, Ron. I can go into more detail for you.

This is the example to which you refer:

update customer as c
   set region =
      (select newregion
         from fixes
        where oldregion = c.region)
 where exists
      (select *
         from fixes
        where oldregion = c.region)

You’re right that there is some redundancy. Both the SET and WHERE clauses of the

We send a lot of emails from our i 6.1.1 partition using the operating system’s SMTP server and a third-party email application. We recently converted from paper to email invoices, which has resulted in a big spike in System i email. Now we’re also seeing more messages returned from our external SMTP relay as “undeliverable.” What’s going on and what can I do about it?

–Glen

Given the increased traffic, it looks like your external SMTP server is being overwhelmed with email demands and that is delaying delivery. The external server may simply be busy and not able to handle