Empower SQL with Java User-Defined Functions
by Michael Sansoterra

Many programming requests routed my way have to do with data transformations of some kind (like moving, copying, importing, exporting, or validating data), so I'm forever using SQL. When I recently started to learn Java, my instinct led me to find out how I could use it to make my life with SQL easier. READ MORE >

OS/400 Alert: All About HTTP Server
by Shannon O'Donnell

In this issue, I will focus on the iSeries HTTP Server. If you are one of the many thousands of OS/400 shops still using the original HTTP server, you are in for a nasty surprise when IBM comes out with the next release of OS/400. If, on the other hand, you are already using the HTTP Server powered by Apache, there is good news for you about ways to improve iSeries Web-serving performance. And, finally, we have to tell you about a possible security hole in your HTTP Server. READ MORE >

Correction

The article "iSeries Access for Web" has been corrected since it was first published. In the set of directions describing how to configure a new Tomcat server, under the section "Creating an HTTP Server," step 7 incorrectly stated that the default port should be changed "to 2016 (or whatever port you used in the previous steps for your HTTP Server)." In fact, the default port should be changed to 2017. Guild Companies regrets the error. [Correction made 10/06/03.] READ MORE >