Numbering Rows in an SQL Result Set
by Ted Holt

As I said on in an issue a few weeks ago, I like functions a lot. In this article, I present an SQL scalar function I wrote a few years ago that has proven itself to be handy. Consider it a Christmas present from Four Hundred Guru. I ho-ho-hope you like it. READ MORE >

List Signed On Users From a Web Page
by Shannon O'Donnell

If you are like me, you receive support calls at the most inconvenient times. For example, when you are at a conference and you don't have access to your own PC. Many times these calls are simply related to poor system performance, and I could resolve some of these issues simply by knowing who is signed on to my system. There are a few users in my company, probably like there are in your own, who are notorious for running complex queries or submitting the same job over and over simply because the first one didn't complete as fast as they thought it should have. Since often times I have access to a PC and the Web, but not access to an emulator, I got to wondering if there was a quick way to see what jobs were running on the system. READ MORE >

   Admin Alert: The Great i5/OS Job Hunt
   by Joe Hertvik

When running an OS/400 or i5/OS help desk, it's not always possible to know which jobs need troubleshooting. Users can provide sketchy information when calling in, and you may not be able to view a troubled session or to remotely log on to user systems to check out problems for yourself. Many times, your first job in helping a user is to determine which job actually has the problem. READ MORE >

Reader Feedback and Insights

We value your feedback and insights. Feel free to send a letter to the editor. Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >

ProData Computer Svcs
Patrick Townsend & Associates
Twin Data