My article, Running Totals in an SQL Query, described how to write an SQL SELECT statement that generated a running total for each row in the result set and provided an example of the SELECT statement syntax to do so.

While the SELECT statement was syntactically correct, it had an omission and did not work correctly in a certain data situation. Several readers figured this out and were good enough to send an email note to make me aware of the situation. I very much appreciate the emails.

I want readers to know that the article was a test

The SysIndexStat catalog view has the column Owning_Index_Owner (plus schema, system names, etc.). However, that catalog view does not include constraint-created indexes, nor does it include keyed logical and physical files that share the access path owned by an SQL index. The DSPFD command does show the SQL index that owns the access path for such logical files, but I have not been able to generate this information in an outfile format from that command.

The information must exist somewhere (since it shows on screen) and I would think it would be in one of the file description APIs, but

I want to email a PC5250 screen shot. But when I press the Print Screen key, nothing happens. It doesn’t copy my screen to the Windows clipboard and I can’t paste it into my email. What am I doing wrong? I’m using the PC5250 product that comes with iSeries Access V5R4M0.

–Jay

By default, most Windows programs capture your entire desktop display image to the Windows clipboard when you press the PRT key (on some keyboards, you press the PrtSc key, instead). PRT copies the entire desktop image to the clipboard, including all visible Windows and the Windows toolbar.

Alternatively,