Sleep Soundly with Hibernate
by David Morris

Java is often considered less capable at reading and manipulating database table data than procedural programming languages, like RPG and COBOL. That's because Java programmers often write procedural code when working with relational data, making it more difficult to take advantage of Java's object-oriented strengths. Hibernate handles this problem by performing many of the mundane tasks associated with database work, allowing Java programmers to concentrate on business requirements instead. READ MORE >

Practical Use of a Translation Table
by Michael Sansoterra

While working on a Microsoft Access 97 project, I was purging and redownloading a large amount of data every night from an iSeries. I noticed that once the data was downloaded, Access took a while to query the data even though there were proper indexes built on the table. READ MORE >

Different Record Formats Without Level Checks
Hey, Ted:

For some time now, you have touted the advantages of using SQL rather than native OS/400 and DB2/400 interfaces. A recent project that I worked on showed yet another advantage that you have not mentioned. READ MORE >

OS/400 Admin Alert: Five Quick PC5250 Tricks for Administrators
by Joe Hertvik

Because it's a mature product, PC5250 has a number of built-in features that the savvy administrator can use to keep his users happy, as well as to make his own life a little easier. Here's a quick list of five handy PC5250 tricks that are useful in an AS/400 shop. All of these tricks were tested with Client Access Express for Windows V5R1M0, but many of these features are also available with other versions of the product. READ MORE >

  OS/400 Alert: Have You Been Snarfed?
  by Shannon O'Donnell

Just when you thought it was safe to talk on your cell phone, along comes a new form of hacking targeted specifically at these devices. Hacking into cell phones or other Bluetooth-ready devices, known in the industry as "snarfing," has just gotten a whole lot easier. Speaking of easy, are you are looking for a way to remove any of those nasty Windows viruses making the rounds these days? I'll tell you where to find the tools you need to target specific viruses. READ MORE >

Correction

The article "A Chicken-and-Egg Trigger Problem" has been corrected since it was first published. A line in the last section of code originally read: "insert into b." The line now reads: "insert into a." Guild Companies regrets the error. [Correction made 2/25/04.]

We value your feedback and insights. Feel free to send a letter to the editor. Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >

T.L. Ashford
Guild Companies
Client Server Development
WorksRight Sofware
COMMON