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

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

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