Numbering Rows in an SQL Result Set

December 14, 2005 Ted Holt

The code for this article is available for download.

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.

I call the function INCR, which is short for “increment.” I wrote it as a way to number the rows returned by an SQL SELECT query. INCR takes one parameter, a number that is one less than

List Signed On Users From a Web Page

December 14, 2005 Shannon O'Donnell

The code for this article is available for download.

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

Admin Alert: The Great i5/OS Job Hunt

December 14, 2005 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.

To that end, here are some tips for quickly finding batch or interactive jobs on your i5, iSeries, or OS/400 systems. These tips were tested by using i5/OS V5R3, but most