Thinking in Sets
Hey, Ted:

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? READ MORE >

Present Timestamps in the Local Time Zone
by Michael Sansoterra

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. READ MORE >