As you may know already from reading some of my earlier tips, I’m a fan of RSE–the Remote System Explorer. I was a user and fan of RSE back in its earliest incarnation in WDSC, then I followed it into RDi (Rational Developer for IBM i), and I’m now using its latest incarnation as part of RD Power, a.k.a. RDP or RDPi (Rational Developer for Power Systems).

One of the benefits of this latest upgrade to RD Power is the new DDS Designer. There was a “Technology Preview” version of the DDS screen designer in earlier RSE versions, but the

Let’s return to a problem I wrote about a few months ago. The technique I illustrated in that article works for most implementations of SQL. Today it’s my pleasure to share a technique you can use with versions of SQL that include certain OLAP functions, such as DB2 for i V5R4 or above.

You’ve been asked to list customer orders that have not been fully shipped, but you are to only show the first unshipped line of each order. Use the RANK() function to assign a sequential number to each row for each order, like this:

select OrderNo, LineNo, 

I print a lot of PC5250 screens but since they only print one page at a time, I have a problem tracking the printouts. The screens are sent to a copier 50 feet away, and they sometimes get collected with other people’s output. How can I print and retrieve all my print screens at the same time?

–Bill

Check out a cool little PC5250 feature called Print Screen Collection, which should do most of what you’re looking for. Print Screen Collection allows you to capture a number of screens to memory and then print them out as a stack of