• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Keep Your Hands on the Keyboard with RSE

    October 1, 2008 Susan Gantner

    Last year, I wrote up a tip with a list of some of my favorite keyboard shortcuts in Remote Systems Explorer (RSE). Later, a slightly longer list of my favorite shortcuts was published on our System i Developer Website as a downloadable list to print and pin up next to your workstation.

    Even using all those shortcuts, there are still many, many things we need to do while working with RSE that would require using a mouse–unless you know a few more shortcuts. So here are a few that you may find useful for those occasions that you want to

    …

    Read more
  • Simulate a Boolean Data Type in a Database Table

    October 1, 2008 Hey, Mike

    I want to create a column in an SQL table and only allow two values. They could be 1 or 0, Y or N, or whatever. I don’t want the database to allow any other values into the column. I want the default to be the “false” value. How would you define such a column in SQL? I understand that Oracle supports a BOOLEAN data type, but I don’t think such exists on the AS/400.

    —Guru Reader

    You are correct, SQL Server has the BIT data type and Oracle has the BOOLEAN data type but there is no equivalent

    …

    Read more
  • Admin Alert: When System Job Tables Attack, Part II

    October 1, 2008 Joe Hertvik

    Last issue, I discussed the ins and out of i5/OS system job tables and how job table overflows can hurt your system. This week, I’ll provide some advice on how to detect and delete excessive jobs that are cluttering your system. Next week, I’ll show you how to maintain the job tables and how to check for job table damage.

    What Are System Job Tables, Again?

    System job tables are internal system objects that i5/OS uses to track partition jobs. There can be up to 10 job tables on a partition, and the maximum number of system jobs for

    …

    Read more

Content archive

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

Recent Posts

  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

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 © 2025 IT Jungle