I have a program that contains a complicated SQL command that selects a group of records exactly the way I want them selected. My boss has added a new wrinkle by creating an exceptions file, which would indicate other records that are to be selected, whether they meet the selection criteria or not. I cannot find a way to add the exceptions file without breaking my query. How do I modify my SQL command to handle the exceptions file?

–Clayton

You were taught the solution to your problem in elementary school. Do you remember learning about sets in math class?

The code for this article is available for download.

For companies with locations in multiple time zones that connect to a central iSeries, time stamp presentation can be a problem. For instance, consider a legacy shipping application that records the date and time of a shipment. If the legacy application isn’t time zone aware, the shipments at the various locations will all be stamped with the date and time of the system’s time zone. A desirable solution for this problem would be a routine that can adjust a timestamp from the main time zone to a local time zone.

Few i5/OS administrators want to log on to a system in the middle of the night, early Sunday morning, or on a holiday just to IPL that machine for PTF application or to correct a problem. Fortunately, the i5/OS and OS/400 operating systems provide a simple way to automatically power down and power up your system anytime you want, even if you are not signed on to the box.

To review all your IPL options and to set up a schedule for automatically IPLing your machine, there are two places to look on an i5, iSeries, or AS/400 box.

First,