• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • 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

    …

    Read more
  • 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

    …

    Read more
  • 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

    …

    Read more

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • IBM i Has a Future ‘If Kept Up To Date,’ IDC Says
  • When You Need Us, We Are Ready To Do Grunt Work
  • Generative AI: Coming to an ERP Near You
  • Four Hundred Monitor, March 22
  • IBM i PTF Guide, Volume 25, Number 12
  • Unattended IBM i Operations Continue Upward Climb
  • VS Code Is The Full Stack IDE For IBM i
  • Domino Runs on IBM i 7.5, But HCL Still Working on Power10
  • Four Hundred Monitor, March 6
  • IBM i PTF Guide, Volume 25, Number 11

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle