If you want to query a record by date on the AS400 DB2, you have to convert a java date to Hundred Year Format. VB has a utility that creates a very close value built in, but I could not find anything for java. Here's my code for future java programmers!
-Tres
public static int toHundredYear(Date d) {
Calendar c = Calendar.getInstance();
c.setTime(d);
return (int)(c.getTimeInMillis()/86400000.0) + 25568;
}